1 Reply Latest reply on Nov 6, 2017 1:08 PM by Shinichiro Murakami

    Calculated Field that remains the same even when applying marks.

    Amethyst Armoogan

      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 A146
      TOTAL

      B

      320
      Total %45.63%
      AB%Region
      2015133.33%East
      173548.57%West
      165728.07%West
      144531.11%North
      196031.67%South
      154831.25%East
      456075.00%West
      Total ATotal B%Region
      356355.56%East
      7815251.32%West
      144531.11%North
      196031.67%South

       

      I am sure there is a simple calculation that I am missing and I would greatly appreciate your help. Thank you!