Jump to content
We've recently updated our Privacy Statement, available here ×

Sorting measure in a crosstab


kalvarez

Recommended Posts



Hi!!

I´m trying to create a crosstab sorting by measure, is there any way to do this, because i can sort by columns and rows but i'm not sure if  i can sort by measure. 
I tried to do it  from my query and check the option "data is pre-sorted" but with a wrong results.

what i need to do is something like this.  An evolution table by year :
 

customers      2008   2009   2010
-------------------------------------------
customer D         2        3          5
customer A          4        1          3
customer C         0        2          2
customer B          1       3          0


I need the measure ordered descending only for the last year 2004, and 2004 is entry from parameter.

Is there any way to do this?

thanks in advanced!!
 

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...