Morning all,
I've got a pivot table that contains two types of value data. I'd like to create a pivot table that shows the monthly split for the first value data but only shows the grand total for the second value data. Is this possible? As a quick and easy solution I just hid the relevant columns (N to Y) but I'm intrigued to know whether it is actually possible?
The attached example hopefully explains a bit more clearly what I'm looking to achieve.
Cheers,
Snook
Bookmarks