Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 

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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:51 PM.


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