Here are the steps to sort a measure column in pivot table.
1) Duplicate your measure column in criteria
2) In the 'fx' window, enter RANK (measure_column)
3) Place this column in the first position of your rows Section of your pivot table. Apply ascending sort order
4) Hide the column
Thanks,
Sandeep Venu
1) Duplicate your measure column in criteria
2) In the 'fx' window, enter RANK (measure_column)
3) Place this column in the first position of your rows Section of your pivot table. Apply ascending sort order
4) Hide the column
Thanks,
Sandeep Venu
2 comments:
Measure column hide property is not working with OBI 11.1.16.7
I have checked the flag available in column property to hide the measure column . Any idea
Pivot report sorting
Post a Comment