I have a crosstab in BO and I wish to select the Top 3 values from the measure in the table. I have tried using the rank function but this does not work.
My crosstab looks something like this:
Name A B C D
Date
01/01 10 8 2
02/01 7
03/01 1 9 6 2
I know I need to use the ‘rank’ formula but I cannot seem to get it to work properly.
Any help greatly appreciated!
My crosstab looks something like this:
Name A B C D
Date
01/01 10 8 2
02/01 7
03/01 1 9 6 2
I know I need to use the ‘rank’ formula but I cannot seem to get it to work properly.
Any help greatly appreciated!