Question on "Showing the rank of a specific item"

[#1]

I have an interesting question:

I created a rank table showing the rank of stores based on revenue....

However, I want to show in the result ONLY 1 shop, showing its rank (on total)...

This is what I want to show in a table:

Store	Turnover	Rank
Store -2 (based on rank)	3,4567.00 €	25
Store -1 (based on Rank)	2,3456.00 €	26
Store I want to report on	1,2345.00 €	27
Store +1 (based on Rank)	1,2344.00 €	28
Store +2 (based on Rank)	1,2343.00 €	29

Been looking for a solution...

Can anyone advise?

[rubenmarin]

Hi Stefan, please check if solution in file attached can help you.

[#3]

Actually not...

When ranking all stores I got rank #27.

I want to see a result with the current rank of the store I want. And then published in a table showing stores ranked before and after...

Do you understand?

[consenit]

Hi there.

I made some modifications to Ruben's document, see attachment.

Kind regards,

Ernesto.

[anbu1984]

Check this

[#6]

the variable "vStoreIRank": what is this? And how do I define it?

It does look like the table i want...

[anbu1984]

vStoreIRank=Max(If(Store='Store I',Aggr(Rank(Sum(Sales)),Store)))

Replace 'Store I' by Store name you want to report

EDIT: This variable stores rank of Sales of Store name you want to report