3 Replies Latest reply on Aug 29, 2018 5:14 AM by Jim Dehner

# Total of percentages calculation query

Hi all!

I have a query in regards to a table I have made which I hope someone can help me with!

I have attached a copy of the packaged workbook.

This contains data for 25 clients in 8 sessions (all random numbers) and I am focusing on Session 1. The date for the data is May 17 - April 18. The sheet also contains some custom sets and dimensions in order to grab the top ten (well, top N) clients and put the others under 'Others'. The first column of data contains the data figures for the session over the 12 months. The second column contains a percentage of the total.

When I change the data to be an average, numbers shown in column one are correct, and the percentage of total calculation works fine. However, the total below the percentages does not quite add up:

Why is this? Is there anything I can do to make that percentage total figure be the sum of the percentages above it (I think it should be around 79.1%)?

• ###### 1. Re: Total of percentages calculation query

Hi

see the attached

the formula below

will return this in your text chart

this happens because table calculations happen after totals in the order of operation

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

2 of 2 people found this helpful
• ###### 2. Re: Total of percentages calculation query

Thank you so much! Order of Operations and LOD Calcs are two things I am now going to look into this week. Thanks for the help, most appreciated.

• ###### 3. Re: Total of percentages calculation query

Thanks

The Order of Operation affects many calculations - when you look into the topic of LOD's also look at Context filters

and when you look at table calculations look at lookup(attr(dim),0) and its affect on the order of operation - it will help you out of some (not all) issues in calculating totals