Rank Function in crosstab

View previous topic View next topic Go down

Rank Function in crosstab

Post  krishna on Tue Oct 25, 2011 11:51 am

Hi i have a Requirement
how to find the rank in corsstab..... detail explanation below
in my report row is region,cloumn is year and measure is sales total...
I want find out the year wise rank based on measure
example below

sales-total Sales 2006 ($) Sales 2005 ($) Rank 2006 Rank 2005
Americas
Europe
Asia-Pacific
Auatralia
Africa


krishna

Posts : 2
Join date : 2011-10-25

View user profile

Back to top Go down

Rank Function in crosstab

Post  Admin on Wed Nov 09, 2011 2:36 pm

Use Report Studio built-in funciton RANK as illustrated below:
1. Introduce a Query Calculation/Data Item named 'Rank'
2. Copy & Paste the expression --> rank (expr/calculated column ASC/DESC)
For Example:--> rank ([tot_Sales] DESC)
3. Save and execute the report.

Admin
Admin

Posts : 10
Join date : 2011-06-02
Age : 39
Location : Bengaluru

View user profile http://www.xpertcog.com

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum