Given the general difficulty of doing much with google pivot table, I expect the answer to be "No".

In the snippet below I would like to keep lines with the totals in green shading and not see the lines with yellow shading.

enter image description here

Clicking the - signs collapses the detail leaving only the total. It also would require a manual step to to go through and check each time the inventory changes.

In effect I want:

"if (number of details lines = 1) then (Don't show total)

Click the [-] button on the row above the subtotal that you want to hide.

  • That does the reverse, -- keeps the total and hides the breakdown. – Sherwood Botsford Apr 4 '18 at 12:38
  • In addition, I was hoping for a way to do this programattically, as I don't want do do this line by line on a 500 line pivot table. – Sherwood Botsford Apr 4 '18 at 12:39
  • @SherwoodBotsford Thanks for the feedback and for updating your question. Regarding doing this programmatically please mention that an add google-apps-script on the question. – Rubén Apr 4 '18 at 14:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.