Displaying two Fields data into same table.

[Shameem]

We have a requirement where we have two Product fields. One is Product (single select), other field is 'Local Product(Multi select)'.

Product and local product are not associated in symantic model. 

Requirment is to when one value of Product filed selected and some values in local product are selected both the selections should be displayed with thier respective volumes into the table .

Eg: Product : Car;  Local Product : Bike , Bus

Result : 

Product	Volume
Car	200
Bike	500
Bus	100

[Shameem]

Hello @tamerj1 , Thank you for reply, I have same values in both Product and local product field. And one is single select and other is multi select respectively, as in UI same screen contains  few metrics which are depending on single select field and few metrics depend on both . Below is the case.

[tamerj1 · Accepted solution]

@Shameem 

[Shameem]

Thank you for the solution.

[tamerj1]

Hi @Shameem 
Please refer to attached sample file with the proposed solution