In my pivot table, I'm able to sort the Dimension using the Sort panel but it doesn't sort the filter. Can someone guide me on how to do it?
Did you use same sorting option in Filter pane?
Yes I did. The dates in the Filter pane is sorted in descending order which is what I want. But the dates in the pivot table's filter is sorted in ascending order.
Try to apply custom sorting as desc in (Filter pane and pivot table ) it should, refer to the attached sample. tks
Retrieving data ...