Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
In the above pivot table i want arrange the time values into sorting and pic the first 5 rows of data.
in sorting tab it showing sorting for name only for expresstion it's not showing why?
Thanks,
Mani
Hi Manikantha,
You can limit the number of values which are being shown like this.
Once done, you can use the sorting panel to sort it the way you need.
Thanks,
Sangram.
In the Sorting section, change the Sorting from "Auto" to "Sort by Expression"
Then in the fx field, put in your measure
Hi,
Take a look at the below link:
Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level)
Hope this helps.
Hi Manikantha,
You can limit the number of values which are being shown like this.
Once done, you can use the sorting panel to sort it the way you need.
Thanks,
Sangram.
Thanks to all,
mein your's also corect
Always Welcome!