P() and E(). Set analysis

[MindaugasBacius]

Hello,

There is a code:

Load *
Inline [
Sale, Supplier, Category
1, RA112, A
2, RA112, B
3, RA112, A
4, RA114, A
];

There is a locked filter Category that I would like to ignore while other filters should remain.

The final TextObject result should be 6.

Thank you!

[skovsgaard · Accepted solution]

Hi

The following expression should give you the correct result.

sum({$<Category = >}Sale)

[PrashantSangle]

or nullify that selection.

like this

=sum({<Category=>}Sale)

Regards,