Excel - General Question on Pivot Table - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

How can I set up a pivot table to show "count of" totals by year across different columns (instead of just filtering year by year)
Solved by O. E. in 19 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 01/07/2018 - 02:21
Hi
User 01/07/2018 - 02:21
Hello
Excelchat Expert 01/07/2018 - 02:21
Welcome to Got it Pro
Excelchat Expert 01/07/2018 - 02:21
Can you please share your excel sheet'
User 01/07/2018 - 02:21
I don't have it, it's on my office computer
Excelchat Expert 01/07/2018 - 02:22
oh ok. Request you to create sample data in excel
User 01/07/2018 - 02:23
Not sue what you mean, I just have a lot of raw output for different events with Start and End Date in 3/10/2017 format
Excelchat Expert 01/07/2018 - 02:23
yes...
Excelchat Expert 01/07/2018 - 02:24
I understand your requirement but would like sample format that will help us to understand better
User 01/07/2018 - 02:25
Something like that
Excelchat Expert 01/07/2018 - 02:25
Ok .. One minute
User 01/07/2018 - 02:25
I want a pivot table where I can set count of total summaries as columns across different date ranges
Excelchat Expert 01/07/2018 - 02:27
Do you want to see Start date wise or End date wise
User 01/07/2018 - 02:27
I want columns for example 2017, 2018, 1H 2017, 2H 2017, 1H 2018
User 01/07/2018 - 02:28
Counting total number of times people have attended different events
User 01/07/2018 - 02:28
and the columns should be for time period
User 01/07/2018 - 02:29
Not sure if I need to create columns in the source data, or if it can be done in the pivot
Excelchat Expert 01/07/2018 - 02:31
Sorry network disconnected
User 01/07/2018 - 02:32
no problem
Excelchat Expert 01/07/2018 - 02:32
I will send you sample
Excelchat Expert 01/07/2018 - 02:32
Please check and confirm
Excelchat Expert 01/07/2018 - 02:32
[Uploaded an Excel file]
Excelchat Expert 01/07/2018 - 02:33
If you want to Quarter wise then we will be able to create in Pivot itself
Excelchat Expert 01/07/2018 - 02:33
If its every 6 months (1H and 2H) then need to create separate columns
User 01/07/2018 - 02:34
I want to have a separate columns for different itme ranges: 1H 2017, 2H 2017, 1H 2018, 2017, 2018
Excelchat Expert 01/07/2018 - 02:34
[Uploaded an Excel file]
User 01/07/2018 - 02:34
Currently I can only filter year by year
Excelchat Expert 01/07/2018 - 02:35
Check this file another version of pivot
[Uploaded an Excel file]
Excelchat Expert 01/07/2018 - 02:35
if you want to see every 6 months need to create a column
User 01/07/2018 - 02:36
that's more like it, but I have Company Name as rows, and I want Columns to be time period totals
Excelchat Expert 01/07/2018 - 02:36
oh ok..
Excelchat Expert 01/07/2018 - 02:37
Please check this version
[Uploaded an Excel file]
User 01/07/2018 - 02:38
yes, that's close..
User 01/07/2018 - 02:38
but how to set it up?
Excelchat Expert 01/07/2018 - 02:38
Ok...
Excelchat Expert 01/07/2018 - 02:38
Just place the cursor in the pivot table
Excelchat Expert 01/07/2018 - 02:38
Drag company name in Row wise
Excelchat Expert 01/07/2018 - 02:38
Start date put it in column
User 01/07/2018 - 02:38
ok thank you
Excelchat Expert 01/07/2018 - 02:38
After that just right click
Excelchat Expert 01/07/2018 - 02:39
Group
Excelchat Expert 01/07/2018 - 02:39
And select how do you want to group the date whether its Month,Years and Quarter select all three so that you will get this output
User 01/07/2018 - 02:39
I see.. thanks
User 01/07/2018 - 02:40
thank you!

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc