Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to create an expression on a pivot table that will calculate some rows based on the users selection but other rows in the same position on the pivot are not to change depending on the NlAccountReportCategoryTypeID=5. This is the expression I am trying to use.
Any help would be grateful.
if(NLAccountReportCategoryTypeID=5,sum([ActualValue*-1]),sum({1<YearEnddate={$(=max(YearEnddate))}>}[ActualValue*-1]))
Hi,
You should be able to use union operator on the sets (I had to reformat the max date as well);
Cheers,
Chris.