Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
sum({<Region = {East},Customer_Enabled = {1}>} Sales)
I have a bookmark with a few customers selected. Now i want above results but WITHOUT the customers that are in the bookmark:
sum({-ExcludedCustomersVolume <Region = {East},Customer_Enabled = {1}>} Sales)
is not working
If ExcludedCustomersVolume is you bookmark name, I think the syntax is a correct syntax, if you want to exclude your bookmark modified with given set modifiers from the total record set.
If you want to just exclude your bookmarked Customers from the first set, try
=sum({<Region = {East},Customer_Enabled = {1}>-ExcludedCustomersVolume} Sales)
If ExcludedCustomersVolume is you bookmark name, I think the syntax is a correct syntax, if you want to exclude your bookmark modified with given set modifiers from the total record set.
If you want to just exclude your bookmarked Customers from the first set, try
=sum({<Region = {East},Customer_Enabled = {1}>-ExcludedCustomersVolume} Sales)
ofcourse .. i'm using now the expression you mentioned. Tnx