Creating an expression that some rows use the select list box but other rows use the whole dataset

[scjma]

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]))

[chrismarlow]

Hi,

You should be able to use union operator on the sets (I had to reformat the max date as well);

Cheers,

Chris.