Hallo everyone,
I have created a Top x report, for example Top 3 customers:
Company Quantity
------------------------------------------
Rabbit Company 2.000
Cat Company 329
Bear Company 118
Remainings 234.870
----------------------------------------
Total 237.317
I would like to append my report so that I got the information how many companies for the Remainings:
Company # Quantity
------------------------------------------
Rabbit Company 1 2.000
Cat Company 1 329
Bear Company 1 118
Remainings 142 234.870
----------------------------------------
Total 237.317
I am facing a difficulty to add this #-column. I am not sure if it is possible, since my row lines are quite complicated specified:
Companies_Top:
topCount ([Companies];?Top x?;[Sum(Quantity)])
Companies_Rest:
except([Companies];[Companies (Top)])
Companies_Rest_member:
member (total(currentMeasure within set [Companies_Rest]);'Remainings';'Remainings';[Our Companies].[Customer])
For the above report, I used:
Companies_Top
Companies_Rest_member
My question:
is it still possible to build the #-column?
Thank you.
Regards,
Ratna