Forum Discussion
Hemant_Jaiswar
Helper I
1 year agoaggregation at customer name level
desired output Month Total 2023 Total 2024 LFL 2023 LFL 2024 Jan 20 35 20 27 Feb 21 31 21 22 Mar 20 37 20 28 Apr 32 33 12 33 Goal: Total 2023: Sum the...
Hemant_Jaiswar
Helper I
1 year agono
- LFL 2023: For each month, calculate the total 2023 sales only for stores that have sales in both 2023 and 2024 for that same month.
- LFL 2024: For each month, calculate the total 2024 sales only for stores that have sales in both 2023 and 2024 for that same month.
and in my output there is only month dimensionMonth Total 2023 Total 2024 LFL 2023 LFL 2024
Jan 20 35 20 27 Feb 21 31 21 22 Mar 20 37 20 28 Apr 32 33 12 33