Running sum (cumulative) in a pivot table and disconnected values from dimensions in pivot table
Hi.
I have a pivot table with following dimensions:
Year, Quarter, Month, Date
Because it is an inventory application, I need running (cumulative) sums with correct totaling, something I can't get so I ask you guys for help 🙂
So which is the correct expression that calculates running sums and which is not dependable on number of dimensions I use in a pivot table?
Is there a way to have an expression which sums values that are not directly connected to the value of dimension shown on rows, but which take that value into account?
for ex.
Year expression
2007 sum all quantitiy fields whose year(posting date)< 2007
2008 sum all quantitiy fields whose year(posting date)< 2008
2009 sum all quantitiy fields whose year(posting date)< 2009
