I have a pivot table with two dimension and one expression. One dimension is aggregation of order_amount on the basis of customer. And another expression is concatenation of current year and month. I have transposed second dimesion from row to column. I need to calculate partial sum of first n rows. Can anybody explain me concept of partial sum?
Before this, I had a pivot table with one dimension and multiple expression(worked as columns). In this case partial sum was giving desired total for first n rows. Does this partial sum vary with number of dimensions? I read soemthing like dimensionality in reference manual, is this related to partial sum?
