topic Partial Sum in Pivot table. in QlikView https://community.qlik.com/t5/QlikView/Partial-Sum-in-Pivot-table/m-p/335824#M123861 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>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?</P><P></P><P>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? </P><P></P><P></P><P>Thanks,</P><P>Kirti</P></BODY></HTML> Mon, 04 Jun 2012 12:42:54 GMT 2012-06-04T12:42:54Z Partial Sum in Pivot table. https://community.qlik.com/t5/QlikView/Partial-Sum-in-Pivot-table/m-p/335824#M123861 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>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?</P><P></P><P>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? </P><P></P><P></P><P>Thanks,</P><P>Kirti</P></BODY></HTML> Mon, 04 Jun 2012 12:42:54 GMT https://community.qlik.com/t5/QlikView/Partial-Sum-in-Pivot-table/m-p/335824#M123861 2012-06-04T12:42:54Z