Changing the value in Inline Field

[sivarajs]

Hello All,

I have a scenario where inline field value has to be changed based on one field selection. Net to Gross and vice versa.

Load * inline [

Measure

Net_Sales

Net_Sales_PY

];

I tried using Replace(Measure,'Net',$(vPrice)) where vPrice gives Net or Gross based on price type selection.

But this gives 4 records two above values and two values with gross.

How best we can change the value dynamically?

[rubenmarin]

Hi you can try adding Price Type field to inline table and have all for values, two of them for Net value in Price type and the other two with Gross value.

Selections in Price Type field will filter the measure values.