Exclude dimension values from table based on dynamic date selection
I am trying to resolve a display issue that is driven by the time period selected by a user. Expression results based on the time period are working correctly. However, I am having trouble getting the proper dimension values to display based on the time period selected. How can I exclude Performer B/Organization 2 from the table below ?
Time Period Selected :
Full Prior Month :
3/1/19 - 3/31/19
Org Activated Date
Org Deactivated Date
Transactions During Time Period Selected
Yes, because org active during a portion of the time period selected - regardless of 0 value in expression results
I want to exclude this row, because org was deactivated before min date in time period selected. But if I suppress 0 values, I lose the row above, too.
Yes, because org active during a portion of the time period selected
Yes, because org active over the full time period selected