Dear all,
i have generated a olap cube and display it using pivot table.
But i am unable to sort my data from acsending order. For example: I had right clicked on my pivot table > field settings > Advanced > Select "Ascending". The data (sum of quantity) remains unsort after i have checked ok.
please help.
cheers
james