5 Replies Latest reply on Dec 19, 2017 6:01 AM by Zhouyi Zhang

    Sum values for TOP N ( to display Total on dashboard)

    Sabine Honer

      Hi All,


      I hope you are doing fine.

      Unfortunately I am stuck calculating the Sum of my Top N values.


      I have search already Internet but couldn't find anything that helped me.


      I have sorted my sum in descending order and just filtered out the Top N values using Index().

      Now I need to sum the values to display it within another chart/table on my dashboard.

      Correct Number is 355 ( currently I am displaying total sum of 793, which is wrong).


      Could you please help me finding a calculation, that works?



      Please find attached workbook.


      In case of questions, please let me know.


      Best regards