I'm in need of help and am hoping for some guidance/direction.
I have a large set of data (8173 rows) spanning back to the beginning of 2022 with the following headers:
What I need to do is break out the data by week and see what the average is by transaction type. I've tried a pivot table but unable to get the calculation needed.
I'm not sure if I need to use and advanced formula.
Thank you in advance.
I have a large set of data (8173 rows) spanning back to the beginning of 2022 with the following headers:
Week # | Date | Branch # | Customer Name | Customer # | Unit # | Unit Status | Folder # | Sent By | Transaction Type |
What I need to do is break out the data by week and see what the average is by transaction type. I've tried a pivot table but unable to get the calculation needed.
I'm not sure if I need to use and advanced formula.
Thank you in advance.