Expert Pivot Help Required

[MikeRobertsMail]

Hi

I have built a view on some data that I want to replicate using a Pivot Table. I'm almost there. I have built 2 Pivot tables, each has part of the solution working, but I need to know how to get it to work in a single pivot table.

Please see the Attachment:

View 1 - this is what I want the final view to look like. Includes Values for the year i.e. F4 is the App for the year of 2011. The row above it is a sum of the items below it. It is Row 2 that causes the problem as it is a running total, but only for that row.

Pvt 1 - this displays the individual values correctly, but the top row, doesn't add the previous value to make it a run total

Pvt 2 - this displays the top summation row correctly as a run total, but the individual values are now running total as well.

Any experts out there who know how to combine the two approaches to it looks like View 1?

Any help greatly appreciated.

Thanks in advance,
Mike