Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I got some problems with filtering and i hope someone can help me.
I have 1 table with 2 fields/measures with differents sources.
"Total Orders" with source "Order".
"Number of Claims" with source "Claim".
I also have these 2 fields that i filter on.
"Date" with both sources.
"Claim Reason" with source "Claim".
When i filter on "Date" it filtering on both measuers, which is correct.
But when i filter on "Claim Reason", then "Number of Claims" filters correct but "Total Orders" gets to 0 because its the "Wrong" source.
How can I make "Total Orders" to not be filtered when i filter on something in field "Claim Reason"?
You can ignore certain filters in your set analaysis.
e.g. Count({<[Claim Reason]=>} OrderId)
You can ignore certain filters in your set analaysis.
e.g. Count({<[Claim Reason]=>} OrderId)
Thank you, it helped!