Cell based Calculation (Crosstab)

[Chamopak]

Hi,

A crosstab was created with some cost centers and a basic calculation.
How can you make a calculation be different for a single cell based on the Row item criteria?


for example the row item j-e-0, instead of getting the Calculation 1 / Calculation 2 it will get (Calculation 1 / Calculation 2
)*-1


Thank you for your help

[oscarca]

Would this work?:

case
when [Amount] = 'j-e-0' then (Calculation 1 / Calculation 2
)*-1
else
Calculation 1 / Calculation 2
end

Best regards,
Oscar