I am trying to create a pivot table where I have to show the Year (dimension) and Count of Customers (Measure/Exp). I have shown this is a bar chart and accumulated the count of customers over years. The approach is very simple in a bar chart. Just click on the accumulation and it works. But the user wants to see the same information in a pivot table.
Now when I calculate the same in the pivot, there is no option to perform an accumulation. Can someone suggest me how to do accumulation in a pivot table.
The requirement is a bit urgent. Any help is highly appreciated.
Since I have the expression by Customer Join Month, the last month has the maximum value. I want to sort this table now in desc order. But when I sort it in desc order, the 1st month starts showing the maximum value after sort. I know that this is because of the expression.