Pivot: turn total row on and off

[#1]

Hello everybody,

one question from my side: is it possible to create a functionality so that a viewer can turn the total row in a pivot table on and off, for example via button. Should be a rather simple requirement, but I've no solution yet.

Regards,

Torsten

[danielrozental]

Only solution I can think of would be through a Macro...

[#3]

Hello Torsten,

you can achive that in a Straight Table, where you can hide a column but not in a Pivot without using a macro, which could be complex.

Is it possible to show your table as a Straight table instead of Pivot??

[#4]

Hi mady mama,

no, pivot table makes sense in this case.

One workaround would of course be to have two tables: one with total, one without and then use auto-minmize. But not very elegant...

[#5]

Hi Daniel,

finally, I agree that a macro might be the solution (cause I found no other way 😉 ).

Does anyone have any examples I can use as a starting point available?