Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Haha. True. But can you search in your profile with some specific keywords for this. No rush, in your spare.
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.
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.
Found one
I have my responded qvw but they are all named by the thread names. How to use them now
Ouch, yeah, that doesn't make it easy to find examples even if you have all the files.
That is a good way! Will be using this for one of my future tables!!
actually, there is a "show total" bottom available now for each measurement, column and row.