Percent of change Day by Day by Category

[Neffri]

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.

[DataNath · Accepted 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!

[Neffri]

Thank you very much it's working :)

I thought that maybe multi row formula will work but something didn't work.