I need to create the table below. However, Deductions % of AR and Ded. 360 PD% of AR are Total AR and AR 360 PD% of AR with a deduction flag filter. The filter has Y or N and these two measures would need to only show values with "Y".
I can't bring the filter onto the whole table or all the values will be filtered with "Y"
Is there a way to have the filter only apply to those two measures? Or can I create a calculated field such as "Total AR with Zded flag "Y"" ... I don't know coding at all as you can tell
Create New Calcs for Both Fields Using Flag "Y" and Replace old with These
IF(Your Measure)="Y" THEN "ABC" END