Hi,
I have a table with the sales of products by month, the user wants to select a Quartely month (March, June, September, December) then the PBI must:
a) Get the Sales amount for the last 4 quarters and summarize it by product.
b) Do the same calculation with other quarter
c) compare both amounts
By Example:
a) the user select from a slicer September 2023, then I need summarize the amounts of (September 2023, June 2023, March 2023 and December 2022)
b) From a second Slicer the user select June 2023, then I need get the amount of June 2023, March 2023, December 2022 and Septemner 2022.
c) show both amounts with the variations by products.
This is an example of my table only with 1 product:
| Product | Month | Amount |
| GG-001 | Jan-22 | 6,759 |
| GG-001 | Feb-22 | 6,323 |
| GG-001 | Mar-22 | 5,915 |
| GG-001 | Apr-22 | 5,534 |
| GG-001 | May-22 | 5,177 |
| GG-001 | Jun-22 | 4,843 |
| GG-001 | Jul-22 | 4,531 |
| GG-001 | Aug-22 | 4,239 |
| GG-001 | Sep-22 | 3,965 |
| GG-001 | Oct-22 | 3,710 |
| GG-001 | Nov-22 | 3,470 |
| GG-001 | Dec-22 | 3,247 |
| GG-001 | Jan-23 | 3,037 |
| GG-001 | Feb-23 | 2,841 |
| GG-001 | Mar-23 | 2,658 |
| GG-001 | Apr-23 | 2,487 |
| GG-001 | May-23 | 2,326 |
| GG-001 | Jun-23 | 2,176 |
| GG-001 | Jul-23 | 2,036 |
| GG-001 | Aug-23 | 1,905 |
| GG-001 | Sep-23 | 1,782 |
| GG-001 | Oct-23 | 1,667 |
| GG-001 | Nov-23 | 1,559 |
In the example above thi will be the results:
| QT | Sum Last 4 Qt | Note |
| Sep-23 | 9,863 | Sum (Sep23, Jun23, Mar23, Dec22) |
| Jun-23 | 12,046 | Sum (Jun23, Mar23, Dec22,Jun22) |
| Variation | (2,183) | |
Can you please help me?
