PDA

View Full Version : Cascading values



K13050
2015-11-22, 01:37 PM
Hi everuone,

Need help with cascading subtotals for a Profit & Loss.

I have used/tried wth David Churchwars example but need some additional twists which i can't get right.


I need to sum on differnt levels, please see attached file. Sheets PLtable and PLpivot is how I would like the sums to be.

All help apprecied.

/Thanks

Herbds7
2015-11-22, 06:57 PM
Excel 2013 Pro Plus
Recommended reading:
"Microsoft Excel 2013, Building Data Models with PowerPivot"
by Ferrari & Russo
http://www.mediafire.com/download/bwzn36fwfj1awge/11_22_15a.xlsx

(http://www.mediafire.com/download/bwzn36fwfj1awge/11_22_15a.xlsx)