Last answered:

15 Jan 2023

Posted on:

17 Nov 2022

1

calculating last year and last Q ?

It seems to me in calculating last year total sales, it write the same values of total sales col but starting in 2012; same with last Q.
you can notice that they are the same values but each has a different row to start in !!!
Also, it must be the same values in total sales for each col when it start to get values !!

2 answers ( 0 marked as helpful)
Posted on:

18 Nov 2022

0

maybe relation between two tables is bi-directional same case is with me

Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Posted on:

15 Jan 2023

0

I guess, the purpose of these calculations is to compare sales now with sales amount which was a year / a quarter ago.

Submit an answer