Creating a Pivot table showing count by quarterly sales

alyssaross

New member
Joined
Jan 5, 2015
Messages
8
Reaction score
0
Points
0
Hello!

Just some quick background.. I have a shared appointment sheet and a sales team that sets appointments inputs related appointment info into a spreadsheet created. based off of that we have several pivot tables showing information showing slaes made from those appointments which salesman has the most sales YTD, ect. I am looking to show a count of appointments made in each quarter shown in a pivot table. Is there an easy way to do this?
 

Attachments

  • Appointments_Made_by_IS - 2015.xlsx
    273.5 KB · Views: 24
Did you ever get help with this? If not, a quick way might be to create an extra column which calculates which quarter you are in, using an IF statement or even a lookup table. Then the pivot table would be able to pull the info.

But - you might want to consider setting up your data differently (only one tab with data, all months in a single column) and then pull all reports using pivot tables off the one table of data.

Hope this helps!
 
Back
Top