8 Replies Latest reply: Apr 10, 2015 7:34 PM by Vishnu Sreekumar RSS

    Issue with pivot table Dimensionality() calculation

    Vishnu Sreekumar

      Hi Experts,

       

      I need you help here.

      I have a pivot table with two dimensions as shown here. "Sum" is an expression which is Sum(Count). All's good till here.

       

      1.png

       

      Now, my requirement is to substitute 0 to any item for which the sum =< 2. So I modified the expression as  expression

      if(Sum(Count)>2,

      Sum(Count),

      0)

      and those items affected by this change are shown by the yellow highlighted rows in below image

      2.png

       

      The problem here is, even though the expression resulting in value 2 (of corresponding to "item 2") is replaced by 0, the partial sum did not change and it still shows 19 instead of 17.

       

      I am attaching the sample file I am working with. Any help would be much appreciated.

       

      Regards,

      Vishnu