Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can please anyone suggest how to implement interactive sorting on pivot table or any alternate method ?
Thanks,
Anand
9030444224
The below two links should help...
Anand,
Sort order on pivot table is decided by the order of the dimensions, so interactive sorting is not possible in pivot table. Since this limitation is within the object, you can create buttons outside the object and you may do it.
Refer Perfectly Sorting Pivot Table (by A-Z. y-Value set for each dim-level)
Siva