Hello, I have this pivot table (data is scrambled)
Like you can see on the top of the table I have dimension with years which I need to sort by numeric value. But in sort sheet i can not see this dimension. Can anyone help me, please?
change the chart type: Pivot Table -> Straight Table and you can sort.
I think empty space is given as caption for Year and Quarter, just click below your cyclic dimension in Sort tab, your year dimension will be highlighted and select Numeric Value - Ascending.
Hope this helps you.
Thanks, that's it
have a look at below post on how to sort pivot table
Assuming that your year dimension is a field (not a calculated dimension), then you can go to Document Properties | Sort and set the default sort order for the year field.
Retrieving data ...