Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How we can sort a pivot table based on measure value.
i have requirement where i need to sort a table based on descending order of measure based on value in di,mension.
for ex : I have DIm1 , Dim2 as Row, Dim 3 as Column and sum(exprn) as measure
now i need to sort the pivot table based on 2 condition
1 ) Dim 3 having one value for ex A
2) Entire table need to be sorted based on Descending value of Measure (sum(exprn)) for "Dim 3 value A"
Hi, can you please share some data? or a qvf, or screenshots?
Cheers
Luis
Like this?
Hi Prashant,
Please let me know if you still have this question.
Cheers,
Luis