Microsoft Office Forums Sort transaction file into Sales Summary

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-09-2019, 02:07 AM
Rogiv Rogiv is offline Sort transaction file into Sales Summary Windows 10 Sort transaction file into Sales Summary Office 2016
Novice
Sort transaction file into Sales Summary
 
Join Date: May 2019
Posts: 2
Rogiv is on a distinguished road
Default 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!
Reply With Quote
  #2  
Old 05-09-2019, 03:28 AM
ArviLaanemets ArviLaanemets is offline Sort transaction file into Sales Summary Windows 8 Sort transaction file into Sales Summary Office 2016
Expert
 
Join Date: May 2017
Posts: 455
ArviLaanemets will become famous soon enoughArviLaanemets will become famous soon enough
Default

Does this do what you want?
Attached Files
File Type: xlsx MonthlyTransactions.xlsx (17.6 KB, 4 views)
Reply With Quote
  #3  
Old 05-09-2019, 05:02 AM
p45cal p45cal is offline Sort transaction file into Sales Summary Windows 10 Sort transaction file into Sales Summary Office 2016
Expert
 
Join Date: Apr 2014
Posts: 268
p45cal has a spectacular aura aboutp45cal has a spectacular aura aboutp45cal has a spectacular aura about
Default

A pivot table, surely. See attached around cell H1.
(I stole Arvi's workbook)
Attached Files
File Type: xlsx msOfficeForums42466MonthlyTransactions.xlsx (15.9 KB, 1 views)
Reply With Quote
  #4  
Old 05-10-2019, 12:46 AM
Rogiv Rogiv is offline Sort transaction file into Sales Summary Windows 10 Sort transaction file into Sales Summary Office 2016
Novice
Sort transaction file into Sales Summary
 
Join Date: May 2019
Posts: 2
Rogiv is on a distinguished road
Default

I finally did a pivot table I think that is the most efficient way. Anyway, thank you!
Reply With Quote
Reply

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
Sort transaction file into Sales Summary 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
Sort transaction file into Sales Summary linking receipt to sales log dumbguy Excel 3 03-08-2013 12:22 AM


All times are GMT -7. The time now is 09:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft