Pivot Table Grand Totals and hiding one field

[vishsaggi]

Hello Experts,

Need an urgent help with this pivot table I have been scratching my brains off.

Really appreciate your help.

I have a pivot table which does not display Grand Total in the bottom, i tried using Partial sum with subtotals in the bottom but I am sure I am doing something wrong here, I am out of thoughts. Please advice....

Please let me know if I have not made it clear.

Many thanks
Vish.

[vishsaggi]

Haha. True. But can you search in your profile with some specific keywords for this. No rush, in your spare.

[vishsaggi]

Or in the same file i uploaded, can you get the GT for Visit by LOC, like All totals of BR TN and XB? Just wondering.

[johnw]

Off topic, but not only have I not kept track of my responses, I somehow lost all of the sample QVWs I wrote or downloaded back in my previous stint on the forum.

[sunny_talwar]

Found one

Pivot Table Functionality

[sunny_talwar]

I have my responded qvw but they are all named by the thread names. How to use them now

[johnw]

Ouch, yeah, that doesn't make it easy to find examples even if you have all the files.

[craig157]

That is a good way! Will be using this for one of my future tables!!

[Anonymous]

actually, there is a "show total" bottom available now for each measurement, column and row.