Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to write an expression with some filer and excluding other one
e.g. sum({<Product={"=sum(Value)>0"}>}sales) here i need sales for product where value for each product should be grater than 0 and it should not affected by any other filter selection.
Thanks!
Add a 1 (one) in front to ignore all other selections: sum({1<Product={"=sum({1}Value)>0"}>}sales)