Hello,
I am trying to create a Workbook to display the following fields sorted by Vendor:
- 2022 Total Purchase Amount
- 2023 YTD Purchase Amount
- Monthly Purchase Amount
I am having issues summarizing 2022 into one column as well as 2023 YTD in another column. I am able to get the monthly purchases by Vendor for 2023.
Was wondering if anyone had any insight into how this could be achieved.
Thank you in Advance!
Nick