Hi All,
I have requirement where I need to fetch the previous Quarter values and calculate it with the current Quarter values aggregating more than a couple of dimensions and present in a table.
Please do help me with a solution here. Thanks all in advance. I have also attached a sample excel file with this post
Please find the below table:
Where ever the Measure says QoQ, I need to take the Current Quarter Actual value and divide it by the Previous Quarter Actual Value with respective to the same Product, KPI and Market and need to display as the table below.
| ReportQuarter | Market | KPI | Product | Measure | Value | comments |
| Q2-2021 | Germany | A | Cookie | Actual | 11.1 | |
| Q2-2021 | Germany | A | Cookie | QoQ | 2.47 | QoQ = current quarter (Q2-2021) actual value / previous quarter (Q1-2021) actual value respective to the Product, KPI and Market |
| Q2-2021 | Germany | A | Cookie | Delta Vs DB | 60.6 | |
| Q3-2021 | Germany | A | Cookie | Actual | 15.33 | |
| Q3-2021 | Germany | A | Cookie | QoQ | 1.381081 | QoQ = current quarter (Q3-2021) actual value / previous quarter (Q2-2021) actual value respective to the Product, KPI and Market |
| Q3-2021 | Germany | A | Cookie | Delta Vs DB | 56 | |
| | | | | | | |
| Q1-2021 | South Africa | A | Cookie | Actual | 14.1 | |
| Q1-2021 | South Africa | A | Cookie | QoQ | 4.5 | QoQ = current quarter (Q1-2021) actual value / previous quarter (Q4-2020) actual value respective to the Product, KPI and Market |
| Q1-2021 | South Africa | A | Cookie | Delta Vs DB | 16 | |
| Q2-2021 | South Africa | A | Cookie | Actual | 11.1 | |
| Q2-2021 | South Africa | A | Cookie | QoQ | 0.787234 | QoQ = current quarter (Q2-2021) actual value / previous quarter (Q1-2021) actual value respective to the Product, KPI and Market |
| Q2-2021 | South Africa | A | Cookie | Delta Vs DB | 60.6 | |
| Q3-2021 | South Africa | A | Cookie | Actual | 15.33 | |
| Q3-2021 | South Africa | A | Cookie | QoQ | 1.381081 | QoQ = current quarter (Q3-2021) actual value / previous quarter (Q2-2021) actual value respective to the Product, KPI and Market |
| Q3-2021 | South Africa | A | Cookie | Delta Vs DB | 56 | |
| | | | | | | |
| Q1-2021 | Germany | A | Ice Cream | Actual | 23 | |
| Q1-2021 | Germany | A | Ice Cream | QoQ | 4.5 | QoQ = current quarter (Q1-2021) actual value / previous quarter (Q4-2020) actual value respective to the Product, KPI and Market |
| Q1-2021 | Germany | A | Ice Cream | Delta Vs DB | 16 | |
| Q2-2021 | Germany | A | Ice Cream | Actual | 30 | |
| Q2-2021 | Germany | A | Ice Cream | QoQ | 1.304348 | QoQ = current quarter (Q2-2021) actual value / previous quarter (Q1-2021) actual value respective to the Product, KPI and Market |
| Q2-2021 | Germany | A | Ice Cream | Delta Vs DB | 60.6 | |
| Q3-2021 | Germany | A | Ice Cream | Actual | 20 | |
| Q3-2021 | Germany | A | Ice Cream | QoQ | 0.666667 | QoQ = current quarter (Q3-2021) actual value / previous quarter (Q2-2021) actual value respective to the Product, KPI and Market |
| Q3-2021 | Germany | A | Ice Cream | Delta Vs DB | 56 | |
