Custom Expression form Different data tables

Hi All,


I am creating cross table visualization where I am combining data from 3 different data sources as follow:

  1. Trend (Budget) - Main data table for this visualization
  2. SRM (Committed Expense)
  3. 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.


Keyur Parekh


(1) Answer