Trouble with displaying information as required

[#1]

Hi,

I wonder if anyone can help me with the following. I am trying to display the following from the data that I have uploaded.

I am trying to display the amount of claims in £ per product. I am having trouble with this as claims and income make up type in the data set, amount is another data set and product is another data set.

Thanks

[#2]

Hi. Have you tried this?

Table dimension: Product

Expression:

sum({<Type={"Claims"},Currency={"GBP"}>}Amount)

OR

sum({<Claims_Flag={1},Currency={"GBP"}>}Amount)