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)

1 Answer 1


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. Apr 4, 2018 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. Apr 4, 2018 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. Apr 4, 2018 at 14:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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