View Full Version : Cascading values

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.


2015-11-22, 06:57 PM
Excel 2013 Pro Plus
Recommended reading:
"Microsoft Excel 2013, Building Data Models with PowerPivot"
by Ferrari & Russo