Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody,
I have a problem with the Rank function.
In my report (which runs individually over 30 outles) only gives the rank of the respective company.
The rank function should create a rank among the outlets for each month and each value description of the value.
My first thought was to calculate a new field in the script. Problem i don't know how to build this formula.
Idea 2 with a formula in a text field, but I also can't get this formula together.
Picture 1 my table
(i created the field rank in excel for demo)
Image 2 The goal
Thanks for any help!
Try this in the text box
aggr( rank(sum({$<Filiale.Filiale=>}BWA.BWA.BWA_Wert),0) , Filiale.Filiale)
Can you attach some sample? what are you getting when you use just the rank function ?
Yes,
the rank function in the table you see is correct. But i need to select a Outlet (Filiale.Filiale) an then i need the rank from the Table in the Textbox.
Thanks for your help
Try this in the text box
aggr( rank(sum({$<Filiale.Filiale=>}BWA.BWA.BWA_Wert),0) , Filiale.Filiale)
Thank you!
It works perfect!