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?
Try this....apologies for any syntax errors, I wasn't able to open attached due to version differences.
Create a field called [Condition] with the formula:
IF [Distance] >= 8 AND [Distance] <= 20 THEN 1 END
Then a 2nd field:
WINDOW_SUM(SUM([Condition])) /
WINDOW_SUM (SUM([Number of Records])
You should be able to add this 2nd field to "Detail" and then include it in a title.