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.
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]