1 Reply Latest reply on Sep 16, 2016 7:38 AM by Steven Carter

    Calculating % from specific values from rows and columns of a barchart

    Ayush Aggarwal



      Is there any way I can calculate % from the rows and columns of a barchart. Worksheet attached. Refer to the screenshot for a better understanding.


      I want to calculate the % of shots which lie in the shaded region(Distance >7 and Distance>21). The calculation will look something like this,

      %= Sum <shots> IF <distance=condition>




      I then should be able to place the % anywhere I like, like Title,Annotation or Caption. Is it Possible?