This content has been marked as final.
Show 1 reply

1. Re: How to calculate the percentage point (pp) between the max. and min.
Yuriy Fal Apr 16, 2018 7:51 AM (in response to Luciana Junqueira)Hi Luciana,
Reference Lines (Bands) are Table Calculations
made on top of their underlying Aggregates
(which in turn could be Table Calcs, too).
So in your case one could grab the formula
from the Percent of Total SUM([Weight]) green pill on Rows
(by double clicking on the pill and copy/paste the calc),
then make a couple of calculated fields in the data schema,
the latter being the 'MaxMin (pp)'.
For the calculation to get the same results as the Ref Line,
the proper Addressing (Compute using) should be set.
Please find the attached.
Yours,
Yuri

X_4_percentage_point_YF.twbx 2.5 MB
