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

      Sabine