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.