Forum Discussion
Comparing FY's In A Matrix From A Single Date Column Within Data Ideally Using SAMEPERIODLASTYEAR
I've searched the forums for hours now, but can't seem to find a solution that will work for me. I'm using a matrix that almost works, but not the way I want. In the matrix below, FY19 is compar...
Hi,
Share sample raw data and show the expected result.
Thanks for your reply. Here's some sample data:
| CUSTOMER | INVOICE DATE | INVOICE TOTAL |
| A | 1/31/2019 | 2836.49 |
| A | 7/25/2019 | 2562.85 |
| A | 11/8/2019 | 2730.3 |
| A | 12/11/2019 | 3013.05 |
| A | 2/18/2020 | 2568.24 |
| B | 1/31/2019 | 844 |
| B | 11/3/2019 | 912 |
| B | 12/31/2019 | 912 |
| C | 9/26/2019 | 2549.97 |
| C | 9/26/2019 | 2829.27 |
| C | 11/21/2019 | 2819.32 |
| C | 11/21/2019 | 2729.44 |
| C | 12/24/2019 | 3442.55 |
| C | 12/24/2019 | 2397.13 |
| C | 2/7/2020 | 2963.6 |
| C | 2/7/2020 | 2746 |
| C | 3/4/2020 | 2923.39 |
| C | 3/4/2020 | 3014.45 |
| C | 3/6/2020 | 2867.81 |
Here's what I need to see in the matrix from this sample data:
| FY19 | FY20 | |
| TOTAL: | 11622.58 | 36039.28 |
| CUSTOMER | FY ($) | FY ($) |
| A | 5399.34 | 8311.59 |
| B | 844 | 1824 |
| C | 5379.24 | 25903.69 |