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.




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




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



      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.