Can someone please help with figuring out how to create day by day % of change for the below data? I'd like to have it broken down by region and country.
As mentioned - below you can find a sample data.
Solved! Go to Solution.
Hey @Neffri, how does this look? The main component we're using here is the Multi-Row Formula to look back up rows and calculate the % difference. We need to handle this in two different streams as for the [REGION] comparison, we need to aggregate up to this level first. At the end, we just join these back up and then apply a sort so that we follow a similar order to what you started with.
Hope this helps!
Thank you very much it's working :)
I thought that maybe multi row formula will work but something didn't work.