Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.