Forum Discussion

Gerald23's avatar
Gerald23
Helper I
4 years ago
Solved

Calculated new rows with filter

Hi all,

 

I have a table that looks like this:

 

 

The problem is that the Online Price for country UK is in Pounds and the Online Price for other countries is in Euro.

 

I would like to add a row to the table when country is UK that calculates the price in EURO that gets a different country name : UK in Eur. I already have the exchange rate loaded in a measure called "EUR per unit for GBP"

 

So it would look something like this:

 

That way i could show it in a matrix view on different columns.
 
Is this possible and if so how could i achieve this?
 
 

2 Replies