I have a pivot table with catalogue items in the left hand column and a Grand
Total column which, depending on the data in the pivot table, could be any
number of columns to the right.
How do I always show the Grand Total for each item, regardless of the number
of columns I have?
I have tried vlookup, allowing for the largest conceivable table array, but
need to vary the col_index_num depending on where Grand Total is. How can I
find this?
(I’m not allowed to use macros and I can’t get my hands on the raw data to
manipulate it before it’s put in the pivot table.)
Thanks for any help. I love all you helpful people!!