How to find rank between 3 to 6 ????

[Former Member]

Hi Experts,

I have a weird situation where i need to find the ranked list between 3 to 6 and display as output.

Refer below screenshot for definitions ( Dimension 'Continent' in Columns and Key figure 'Revenue (Rank) ' in Rows which is a ranked list)

Refer below screenshot for how condition is defined.

This condition doesn't give the expected result since the time of execution of calculations tab is only at run-time.

Output

Kindly guide me on this scenario to display the ranked list between 3 to 6.

Thanks in advance.

Regards,

Babu

[Former Member]

Hi Ganesh,

    By using the Condition try to define two conditions.

1. Greater than or Equal to 3   and

2. Less than or Equal to 6

Try with this condition it would give you a desired output.

Regards,

Kishor

[Former Member]

Hi Kishor,

Thanks for your reply.

Above mentioned solution does not give the desired output.

Also, I have tried as two statements inside a condition too.

In both the ways, desired output is not achieved.

Thanks,

Babu

[Former Member]

Create a now formula below the Rank Revenue.

Hide the rank Revenue.

In the formula:

  (( Rank Revenue >= 3 ) and ( Rank revenue <= 6 )) * Rank revenue + 0

Hide the Rank Revenue Display the formula.

Do zero suppression.

It might work out.

[Former Member]

Thanks for your reply.

This option will not work out because

• Rank is calculated as single values in Calculations tab .So, if you consume the same Key-figure in another formula, it will not give the rank number, instead it will give values only that underlying formula / info-object fetches.

                   

But I have verified your option too, it fetches the following result since the zero suppression is active

If zero suppression is not active, it will give output with all values as zeros.

Thanks

Babu

[former_member220624]

Hi,

So you want to display those continenets which fall in rank 3-6 ?

What is defined in the selection 'Revenue (Rank)' ?'

Do you have data present in underlying info-providers ?

Are you doing some sort of aggregation ?

Regards,

Amit

[Former Member]

Hi Amit,

Thanks for your immediate reply.

Yes. I want to display continents which falls in rank between 3 and 6.

Please refer below screenshot for definition of selection 'Revenue (Rank)'

Yes. I have data present in underlying info-providers.

No. Only standard aggregation is allowed in selection. Refer below screenshot

Thanks,

Babu

[Former Member]

Hi Babu,

Could you please share screen shot of characteristics assignment for the Condition defined for Revenue (Rank).

Regards,

Nikhil.

[Former Member]

Hi Nikhil,

Thanks,

Babu

[Former Member]

Hi,

you define it in a correct way, some time conditions works weird , change the condition characteristic assignment from all char to "individual char and combinations" and choose the continent .. save , run report and see .

[Former Member]

Hi Jyothi,

Thanks for your reply.

I have tried with all the possible combinations of Characteristic assignment but i have no luck on result.

Thanks,

Babu

[Former Member]

Hmm.. try changing the Key figure  calculation properties -->calculation directions -->calculate along rows instead of default direction.

[Former Member]

Changing calculation directions along rows / columns give the same result on execution.

Thanks

Babu

[Former Member]

Hi Ganesh,

Apart from this condition , do you have any other filters on this key figure? did you check the report results for the key figure with calculation result as "rank" first? do you have any values for 3,4,5,6 ranks?

[Former Member]

I am not defining any filters or restrictions on this key figure.

Yes. It has values for ranks 1 to 7. Below is the output screenshot when condition is inactive.

Thanks,

Babu

[former_member220624]

Hi Ganesh,

Just curious, what is the data type for Revenue (rank) key-figure ?

If possible can you please share the logic behind calculating rank values.

Regards,

Amit

[Former Member]

Hi Amit,

There is no separate logic behind in calculating rank number.

You can navigate to "calculations" tab and choose single values as "Rank number".

This will straight away gives you the Rank values.

Thanks,

Babu