1 Reply Latest reply: May 15, 2013 7:21 AM by Gysbert Wassenaar RSS

    Partial Sums in Pivot Tables

    Manish Chauhan

      I have a simple Pivot Table chart that has the Fund and Date as dimension. I have an expression that is based simple x(k,i)/N(k).... where x(k,i) is some value for the the Fund k and date i. And N(k) is some value for Fund k. The number is a %.


      Currently the Partial sum is simply a Summation of x(k,i)/N(i). This is fine for the date Total, but not the summation I require across for the Fund Total.


      Example: 2 Fund, A, B. Across 1 date - Jan 2013.


      Fund Total (0.6%) <---------------- I would expect to see 0.3% here also, but instead see 0.6%

      A Jan 13: (0.3%)

      B Jan 13: (0.3%)


      Fund total should be  ( x(A,i) + x(B,i) )/ (N(A)+N(B))


      What happens is I get Summation of x(A,i)/N(A) + x(B,i)/N(B)


      Is there anyway of specifying how I can do the Partial Sums at different hierarchal levels in a pivot table in Qlikview?