This content has been marked as final. Show 8 replies
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.