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"
