Home |
Search |
Today's Posts |
#1
|
|||
|
|||
PivotTable - Count by Month
I have a spreadsheet for daily sales. Details of each sale (including Date,
Order No, Product, Quantity, Unit Price, Discount, Total Price, etc) are recorded on each row. The Date format is "dd/mm/yyyy (ddd)". I would like to create a PivotTable to count the total sales of each product for each month. However, I am having problem to do the count by month. Currently, I have to add another Month column (and then hide the Month column) in front of my Date column to indicate the month, and in order to do the count by month in my PivotTable. Is there a smarter way of doing the above? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UserForm to select current month or earlier | Excel Discussion (Misc queries) | |||
How to extract month number from month name | Excel Discussion (Misc queries) | |||
How do I set permanent secondary axis in PivotTable chart? | Charts and Charting in Excel | |||
Count If Formula | Excel Worksheet Functions | |||
count based on two fields - need quickly | Excel Worksheet Functions |