Hi,
I am trying to get a pivot table to work with multiple columns.
This is the data I have:
This is the results set
Can anyone help with this?
I am trying to get a pivot table to work with multiple columns.
This is the data I have:
| Customer | Name | Credit Limit | Date | Sales |
| AA | A&A Paper Corporation | 3000 | 2024-03 | 5,329.50 |
| AA | A&A Paper Corporation | 3000 | 2024-02 | 2,340.00 |
| AA | A&A Paper Corporation | 3000 | 2024-01 | 2,524.50 |
| AA | A&A Paper Corporation | 3000 | 2023-12 | 2,340.00 |
This is the results set
| Customer | Name | Credit Limit | 2024-03 | 2024-02 | 2024-01 | 2023-12 |
| AA | A&A Paper Corporation | 3000 | 5,329.50 | 2,340.00 | 2,524.50 | 2,340.00 |
Can anyone help with this?
