how to compare values using formula tool

[rohitchat20]

Hi, I have data like below - 

Now for a SKU, i have to compare elasticity value for variable base_price VS cann_price_index_ppg1 that which one is higher. how can I do that using formula tool or some other tool.

[flying008]

Hi, @rohitchat20 

1- Filter [Variable] with:  

[Variable] in ('base_price', 'cann_price_index_ppg1')

2- use  Summarize  tool to :

Group by [sku]

Max by [Variable]