Nested set analysis difficulty

[#1]

Hello,

I have a pivot table in my application with the following expression:

=Sum ({$<MainDate_YYYY={$(=max(MainDate_YYYY)-1)},[%DistributionChannel] = {"<>01"}>}[#OrdLine_Net Value (€)])

I would like to add somewhere in this set analysis that [Ord_Sales Document Category]<>'K'.

I tried the following syntax: =Sum ({$<MainDate_YYYY={$(=max(MainDate_YYYY)-1)},[%DistributionChannel] = {"<>01"},[Ord_Sales Document Category] = {"<>K"}>}[#OrdLine_Net Value (€)]), but with no luck.

I also tried adding a calculated dimension like this: =Aggr(Only({$-<[Ord_Sales Document Category] ={"K"}>}[Ord_Sales Document Category]),[Ord_Sales Document Category]) which worked, but I can't hide the column in a pivot table.

Any idea, please?

[Anonymous · Accepted solution]

Try this (notice the minus sign):

[Ord_Sales Document Category]-={'K'}

[#3]

Yes, thank you! It works. I tried all sort of things, but I still have a lot to study...

[Anonymous]

Me too