Hi,
I've created a pivot table to tell me the monthly sales total by year and period. Is it possible to get the pivot table to create a calculated column that gives me the cumulative position? Also my pivot lists the data in the wrong order because of its format as the year and periods 2009/10-12 are above 2009/2-9. Is there any way to change the data sort rule so it recognises the correct order?
I've attached an example of the pivot I am working on and an example of how I would like it to look.
Thanks in advance,
Snook
Bookmarks