Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
The cumulative sum in pivot will work based on the dimensions and their values. As of your data, there is no constant combination of rows against the dimension for the cumulative sum.
E.g
A 101 1 21/5/17 2
A 101 2 21/5/17 3
A 111 1 22/5/17 4
For understanding purpose to check the cumulative sum, make the first value as it is of 2nd and check the cumulative property in presentation.
Regards
Try Total<Product> where you have used Total in the expression.
Don't create double post for single Issue
why 2,3,9,2,3,4 ?!? , I don't understand how you calculate this
Please delete as duplicated post
just delete it...