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!
Hi Amethyst
If you mean hit result, you can use LOD.
Overview: Level of Detail Expressions
Thanks,
Shin