How do you apply ranking on crosstab ..? Is there any limit for rows and columns in the crosstab

  • Interview Candidate
  • 9
  • 6863

Showing Answers 1 - 9 of 9 Answers

Hariom Sharma

  • May 30th, 2007
 

Slice Dice is a place where you can apply rank.

  Was this answer useful?  Yes

jemimaplatina

  • Jan 13th, 2010
 

In the cross tab define the rank based on the lower level object you are pulling into the report.
example: one country can have multiple states. One state can have multiple cities. If you are pulling all the three objects (Country, state, cities) into report and want to define rank based on population then define the rank based on cities.

  Was this answer useful?  Yes

VIKRAM KUMAR

  • Mar 8th, 2018
 

We can apply ranking function in cross tab at WEBi report by creating a variable as =Rank(Sum() in dimension name) or we can go for creating a variable for the sum of the measure that we have along with dimension to represent in cross tab such as =Sum([measure]) and then base our rank on the variable rather than the measure.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions