Update a row with calculation of two rows in Pivot table

[Sandya_K]

Hi,

I need to update a row in pivot table with calculation from two other rows. 

In this example, ITEM CLOSE RATE will be ITEM / ITEM QUAL

and ITEM2 CLOSE RATE = ITEM2 / ITEM2 QUAL

If(METRIC= 'ITEM CLOSE RATE', Sum({<METRIC={'ITEM'}>}KPIValues) / Sum({<METRIC={'ITEM QUAL'}>}KPIValues), Sum(KPIValues))

I get blank values for close rate row.

Can you please assist?

Thanks.

[vinieme12]

=If(METRIC= 'ITEM CLOSE RATE', ACTUALEXPRESSION FOR ITEM / ACTUALEXPRESSION FOR ITEM QUAL)

[Sandya_K]

I tried the below set expression but it doesn't work.

If(METRIC= 'ITEM CLOSE RATE', Sum(${<METRIC={'ITEM'}>}KPIValues) / Sum(${<METRIC={'ITEM QUAL'}>}KPIValues), Sum(KPIValues))