Hi. I am using a pivot table that has multiple years as one of the columns. Is there any way I can get a grand total of each year? Currently the grand total is of both years.
Thanks.
Hi. I am using a pivot table that has multiple years as one of the columns. Is there any way I can get a grand total of each year? Currently the grand total is of both years.
Thanks.
what you are after is subtotal by year
if you group your pivot table by year it should automatically include a subtotal by year
there can only be 1 GRAND total, otherwise that would defeat the meaning of the word
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks