Sorting Data From Olap Pivot Table

  • 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

    Warmest regards
    James

  • Re: Sorting Data From Olap Pivot Table


    Can you post a sample of the data?


    How many columns do you have? Whats in each column?


    Brad.

    Brad.

  • Re: Sorting Data From Olap Pivot Table


    to the best of my Knowledge you can not sort OLAP cubes in excel, i've had to create macros to get the data out of the cube and then process the sorting...

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!