straight table expression

[savithri_n_s]

Hi,

I have 2 tables. One is Spend table and another is  contractor table. I am trying to link the data of both the table in Straight table

in sheet 5 of attached Qvw

I am getting same values in the row highlighted below. Can you please help what is wrong here?

Your help is greatly appreciated

Regards,

Savithri

Message was edited by: savithri Ns Thank you . Can you please tell me how can we write expression to get sum[Spend USD2] where [Preferred Supplier] column is non blank And also Can you please tell me how can we add FY18 Average based over calculated expression in dashboard 5 of qvw

[settu_periasamy]

The two table's are connected with 'country' field. But, you have Calendar field also.

When you put a dimension as Calendar field(MonthYear), It will give the total value.

Try to change the keyfield like country & YearMonth.