#1
|
|||
|
|||
Sort transaction file into Sales Summary
Hi everyone, I have a huge file about transaction that has 5 columns (Date, Product Name, Quantity, Price, Total Price), example like below:
Date Product Name Quantity Price Total 2019-01-01 A 2 $100 $200 2019-01-01 B 5 $50 $250 2019-01-01 B 50 $50 $2,500 2019-01-01 C 3 $30 $90 2019-02-01 B 1 $50 $50 2019-02-01 B 5 $50 $250 2019-02-01 B 1 $50 $50 2019-02-01 B 10 $50 $500 2019-03-01 C 3 $30 $90 2019-03-01 B 1 $50 $50 My question is, is there a way to sort this file into a total amount sold for every product in every month? I expect the output will be something like: Jan Feb Mar Total A 2 0 0 2 B 55 17 1 73 C 3 0 3 6 Thank you in advance! |
#2
|
|||
|
|||
Does this do what you want?
|
#3
|
||||
|
||||
A pivot table, surely. See attached around cell H1.
(I stole Arvi's workbook) |
#4
|
|||
|
|||
I finally did a pivot table I think that is the most efficient way. Anyway, thank you!
|
Tags |
filter formula, filtering, sort |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
sales template | pingshaik | Excel | 0 | 03-11-2018 09:12 PM |
How to calculate summary progress date time on summary tasks | Logotip | Project | 0 | 05-16-2017 01:18 AM |
Exchange 2010 Recovery without EDB File / only transaction logs | peterweav880 | Misc | 1 | 12-22-2014 10:48 PM |
Rollup Summary Tasks to Project Summary Task | shep555 | Project | 1 | 05-24-2014 12:28 PM |
linking receipt to sales log | dumbguy | Excel | 3 | 03-08-2013 12:22 AM |