Custom Expression form Different data tables
I am creating cross table visualization where I am combining data from 3 different data sources as follow:
- Trend (Budget) - Main data table for this visualization
- SRM (Committed Expense)
- DB1 (Actual Expense)
I have following custom expression in the axis
Sum([Trend]) , Sum([SRM].[Open Commitment $]), Sum([DB1].[Actual])
Now the issue is I have to limit few rows from DB1 and the expression for this is [YR Category] <> "Re-Invoicing".
How can I incorporate this change in above expression so that my cross table visualization represents rows except "Re-Invoicing" from table DB1.
Thank you so much for your time.