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

      Hi,

       

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

             Sum<shots>

       

       

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

       

       

       

       

       

       

      1.jpg