I have data as below for 5-6 Years(Sampled from Excel- Actual Data is on row level in Alteryx), Consider Current year as 2021,
Current Data | | | | | | | | | | | | |
|---|
| Jan '21 | Feb '21 | Mar '21 | Apr '21 | May '21 | Jun '21 | Jul '21 | Aug '21 | Sep '21 | Oct '21 | Nov '21 | Dec '21 |
Buisness 1 | 0.50 | 1.00 | 1.50 | 2.00 | 2.50 | 3.00 | 3.50 | 4.00 | 4.50 | 5.00 | 5.50 | 6.00 |
Buisness 2 | 0.60 | 1.10 | 1.60 | 2.10 | 2.60 | 3.10 | 3.60 | 4.10 | 4.60 | 5.10 | 5.60 | 6.10 |
Buisness 3 | 0.70 | 1.20 | 1.70 | 2.20 | 2.70 | 3.20 | 3.70 | 4.20 | 4.70 | 5.20 | 5.70 | 6.20 |
Buisness 4 | 0.80 | 1.30 | 1.80 | 2.30 | 2.80 | 3.30 | 3.80 | 4.30 | 4.80 | 5.30 | 5.80 | 6.30 |
Allocation | 2.00 | 2.50 | 2.00 | 2.00 | 2.50 | 2.00 | 2.00 | 2.50 | 2.00 | 1.63 | 2.00 | 2.50 |
Total | 4.60 | 7.10 | 8.60 | 10.60 | 13.10 | 14.60 | 16.60 | 19.10 | 20.60 | 22.23 | 24.60 | 27.10 |
I need to calculate 12 month Average and total of these 4 business using 2020 Data as below
12 month Average and its total | | | | | | | | | | | | |
|---|
| Jan '20 | Feb '20 | Mar '20 | Apr '20 | May '20 | Jun '20 | Jul '20 | Aug '20 | Sep '20 | Oct '20 | Nov '20 | Dec '20 |
Buisness 1 | 1.50 | 2.00 | 2.50 | 3.00 | 3.50 | 4.00 | 4.50 | 5.00 | 5.50 | 6.00 | 6.50 | 7.00 |
Buisness 2 | 1.55 | 2.05 | 2.55 | 3.05 | 3.55 | 4.05 | 4.55 | 5.05 | 5.55 | 6.05 | 6.55 | 7.05 |
Buisness 3 | 1.65 | 2.15 | 2.65 | 3.15 | 3.65 | 4.15 | 4.65 | 5.15 | 5.65 | 6.15 | 6.65 | 7.15 |
Buisness 4 | 1.75 | 2.25 | 2.75 | 3.25 | 3.75 | 4.25 | 4.75 | 5.25 | 5.75 | 6.25 | 6.75 | 7.25 |
Total | 6.45 | 8.45 | 10.45 | 12.45 | 14.45 | 16.45 | 18.45 | 20.45 | 22.45 | 24.45 | 26.45 | 28.45 |
