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

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

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).

In case of questions, please let me know.

Best regards

Sabine

• ###### 1. Re: Sum values for TOP N ( to display Total on dashboard)

Hi, Sabine

Below is the sample result

Hope this could help

ZZ

• ###### 2. Re: Sum values for TOP N ( to display Total on dashboard)

Hi ZZ,

thank you very much for the awesome approach.

Unfortunately I can't get it to work here.

Would you mind having a look at Sheet5 and see, what am I doing wrong?

I am really sorry....

Best regards

Sabine

• ###### 3. Re: Sum values for TOP N ( to display Total on dashboard)

I got it :-)

Thank you very much :-)

• ###### 4. Re: Sum values for TOP N ( to display Total on dashboard)

Hi, Sabine

Don't say sorry, we are here just for learning from each other and help each other.

You are almost there to my solution, please see my screenshot below

Let me know if further question.

ZZ

• ###### 5. Re: Sum values for TOP N ( to display Total on dashboard)

Cool ~~