Im sure there is a simple solution to this but I just cant wrap my head around it.
I have a division problem that gives me a %. When I add it to another formula and only have it yield one line graph it is accurate however if I split that by region it breaks up the percentage across all the regions when the % should be the same for all regions as it is the company %.
Example:
I have this data for a bunch of dates (this is a one day example) and my formula is automatically breaking down the region (the lines in my graph) and I just want it to show the Total % in the tool tip not it by region.
| TOTAL A | 146 | | |
| TOTAL B | 320 | | |
| Total % | 45.63% | | |
| | | |
| A | B | % | Region |
| 20 | 15 | 133.33% | East |
| 17 | 35 | 48.57% | West |
| 16 | 57 | 28.07% | West |
| 14 | 45 | 31.11% | North |
| 19 | 60 | 31.67% | South |
| 15 | 48 | 31.25% | East |
| 45 | 60 | 75.00% | West |
| | | |
| Total A | Total B | % | Region |
| 35 | 63 | 55.56% | East |
| 78 | 152 | 51.32% | West |
| 14 | 45 | 31.11% | North |
| 19 | 60 | 31.67% | South |
I am sure there is a simple calculation that I am missing and I would greatly appreciate your help. Thank you!
Nov 6, 2017 1:08 PM
