Hi All, Looking for your support on this query.
I have this data as seen in the image. The first five columns are from the source. Now I need to create the percentage and a Flag which gives a binary output of either 0 or 1 based on input variable.
Threshold - this is a input variable which changes .
% = num/den
Flag = %> Threshold then 1 else 0
I have added the images with three scenarios, where based on what dimensions are selected , only the highlighted rows must be shown in the pivot.
Problem is , how to add the created measure as filter and select either only 1's or 0's? I have tried "%" being loaded from both load script and as created measure and none of this works.
From load script when added as field, for few rows the percentage is not being calculated but the filter works.
From creating measure using set analysis( sum(num)/sum(den) ), I get the right percentage but unable to filter only 0's as Flag is dependent on a measure .
Looking forward for your support !
