none
How to show top n values in a stacked column chart RRS feed

  • Question

  • Hi,

    I have amounts for each field for year.  On a stacked column chart, I want to show top 3 fields for each year. And for each year rest of the field should be shown 'under other category'.

    Year Fields Amount
    2019 A 100
    2019 A 50
    2019 B 200
    2019 B 300
    2019 C 50
    2019 C 50
    2019 D 10
    2019 D 20
    2019 E 50
    2019 F 10
    2020 A 10
    2020 A 20
    2020 B 500
    2020 B 10
    2020 C 200
    2020 C 50
    2020 D 800
    2020 E 900
    2020 F 40


    Thursday, May 2, 2019 8:08 PM

Answers

All replies