6 Replies Latest reply on Jul 31, 2018 9:37 AM by Jim Dehner

# Help Needed: % Change calculation on a % of Total Calculation

Technical question for you all. I want to show the following on the tooltip for the top view.

The top view shows a % of total split for our case volume for our call center. Additionally, I want to show the % change compared to the previous period. For example, if yellow goes from 20% (20/100 cases) to 10% (20/200 cases) of the total I want the tooltip to reflect a -50% change vs. a 0% change. The % change is calculating on the underlying counts, not the % of change.

• ###### 1. Re: Help Needed: % Change calculation on a % of Total Calculation

Hi samuel,

use the calculation as

(count(orders)-lookup(count(orders),-1))/count(orders)

Hope this helps

Kindly mark this answer as correct/helpful so that it will help others

BR,

NB

• ###### 2. Re: Help Needed: % Change calculation on a % of Total Calculation

Naveen - this did not work. It doesn't show the % change - any other ideas?

• ###### 3. Re: Help Needed: % Change calculation on a % of Total Calculation

Hi Samuel,

Could you please sample attach the workbook Please with some Mock up data

BR,

NB

• ###### 4. Re: Help Needed: % Change calculation on a % of Total Calculation

Good morning

Please see the attached

the formula for the initial % of total is

then the change in that percent is

it will return this

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.

• ###### 5. Re: Help Needed: % Change calculation on a % of Total Calculation

Thanks jim - it works up until the final point. I believe it's because my % of orders has totals summarize values from table (across) vs. table (down). Any recommendation on how to fix that?

• ###### 6. Re: Help Needed: % Change calculation on a % of Total Calculation

don't like not seeing the data in a twbx workbook - guessing that this might work

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.