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 %.
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||Total B||%||Region|
I am sure there is a simple calculation that I am missing and I would greatly appreciate your help. Thank you!