Expert Solution - General Questions on Pivot Table

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

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?