How to show Top 11-20 Entity Members

Chiara Fabris
Chiara Fabris Active Partner
Fourth Anniversary Board Developer Level 300: Expanding Board in Your Organization Level 200: Building A Planning Solution in Board
edited August 2020 in Platform
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
------------------------------

Answers

  • Akash Saxena
    Akash Saxena Customer
    Second Anniversary First Comment Photogenic
    edited August 2020
    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
    Shuyu Kameda Active Partner
    Second Anniversary First Comment
    edited August 2020
    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
    ------------------------------
    -------------------------------------------

Categories