Pivot tables - grand totals with a detail split

[Pedo00ab]

I created a pivottable with five columns (1 to 5) that are each split i
current week or peak week (total of 10 columns). My problem is that
would like to add a grand total column that are also split in curren
week and peak week.

But it keeps on adding all the 10 columns together in one Grand Tota
column.

Does anybody know how to fix this?

Pete

 

[BrianB]

You probably need to add another column to the raw data to be able t
analyse the way you want