How to show Top 11-20 Entity Members

Hi everyone,
I have to show the range 11-20 Clients by turnover in a chart.

Is there a dynamic way to do that, without a procedure but using layout functionality?

Thank you,

Chiara

------------------------------
Chiara Fabris
Consultant
KVALUE SRL
Italy
------------------------------

Find more posts tagged with

Accepted answers

All comments

Akash Saxena

Hi Chiara

Try this

1. Sort the data in descending order
2. Add a column algorithm showing value "1"
3. Add next column algorithm under ranking category and choose "cumulated value". This indeed will return you the ranking of items
4. Filter the required ranking basis algorithm in step 3.

- Akash Saxena

------------------------------
Akash Saxena
Consultant
Ernst & Young LLP- India
India
------------------------------
-------------------------------------------

Shuyu Kameda

Hi, @Akash Saxena

I'm facing this same problem.
Your idea is a great one.
However, when I tried your method in my environment, it was only successful up to step 3.
The filter for "cumulated value" does not work.

The data cube consists of a Month entity and a dummy entity (with A and B as members)
The layout is a data cube, "1", and "cumulated value".

Thank you,

------------------------------
Shuyu Kameda
??????
ZEAL CORPORATION
Japan
------------------------------
-------------------------------------------