Hi,
I have a report in which I've pulled in the following custom dimensions:
1. Inventory On Hand with date advanced filter of Today
2. Quantity Sold with date filter of last 7 days
3. Quantity Sold with date filter of last 30 days
I'm looking for a way to then only display records in the report in which at least 1 of the measures above does not equal 0, meaning there was some kind of activity in one of those measures. While I can add a filter for each individual custom measure, that doesn't work since it will only display records in which all 3 records are not 0. Is there a way to use a custom filter or create a new customer dimension with a Yes/No value of all 3 are equal to 0.
I can't find any information on how to create a custom filter or dimension in which I pull in a measure and also apply a date filter and say the value has to not be 0.