Excel - General Question on Pivot Table - Expert Solution

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

Hey there. I can't find a easy way to generate a pivot table exactly as i want to see it. I might need some calculated column but i'm never used this feature and i'm not sure.
Solved by M. Y. in 12 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 10/12/2016 - 11:48
hey
Excelchat Expert 10/12/2016 - 11:48
Thanks for choosing Live Spreadsheet Help! It’s my pleasure to help you out today.
Excelchat Expert 10/12/2016 - 11:48
I’d love to help you with your problem if you would kindly give me more information.
User 10/12/2016 - 11:48
not really. I can explain exactly my issue
Excelchat Expert 10/12/2016 - 11:49
Please sir...
User 10/12/2016 - 11:49
i'm generating a pivot table from a table.
User 10/12/2016 - 11:50
i'm ok choosing the coluns that i want to show in the lines and picking the column that i wan to count
User 10/12/2016 - 11:50
this column that i'm couning...
User 10/12/2016 - 11:50
is about 1,5k values. This is the total.
Excelchat Expert 10/12/2016 - 11:51
Sir please let me know what you want to do now.
User 10/12/2016 - 11:51
however, i'd like to have another column in my pivot table with the count of the same column BUT with a filter
User 10/12/2016 - 11:51
i don't know how to make to columns in my pivot table with the same field
User 10/12/2016 - 11:51
with the same column of the table i'm using to generate the pivot table.
User 10/12/2016 - 11:52
i'm sorry english is not my first langague. Was it clear enough?
Excelchat Expert 10/12/2016 - 11:52
Sir please upload your sheet here so that i can take a look
User 10/12/2016 - 11:52
i didn't earliler because there is confidential info
User 10/12/2016 - 11:53
i'd waste some time generating ramdom data to show you
User 10/12/2016 - 11:53
let me try again:
Excelchat Expert 10/12/2016 - 11:54
I think you can create same column by creating a group.
User 10/12/2016 - 11:54
i want to have same column but with different filters in each one
User 10/12/2016 - 11:54
the same pivot table
User 10/12/2016 - 11:55
i have a table that i generated the pivot table from
Excelchat Expert 10/12/2016 - 11:55
Yes sir you can do this by creating group in pivot.
User 10/12/2016 - 11:55
i want a column from this table shown 2 times as 2 columns in my pivot
User 10/12/2016 - 11:55
how do i create a group?
User 10/12/2016 - 11:56
but with different filters in each column.
User 10/12/2016 - 11:56
i'm googling it
Excelchat Expert 10/12/2016 - 11:56
Ok sir i am telling you the steps.
Excelchat Expert 10/12/2016 - 11:57
1. Control-click to select each item in the first group.
Excelchat Expert 10/12/2016 - 11:57
2. Right-click one of the items and choose Group from the menu
Excelchat Expert 10/12/2016 - 11:57
3. Excel creates a new group, "Group1"
Excelchat Expert 10/12/2016 - 11:58
4. Select your counts in column B, and group as above
Excelchat Expert 10/12/2016 - 11:58
5. Excel creates another group, "Group2"
Excelchat Expert 10/12/2016 - 11:58
For more information you can visit here
Excelchat Expert 10/12/2016 - 11:58
https://exceljet.net/things-to-know-about-excel-pivot-tables
User 10/12/2016 - 11:59
hey. thanks a lot. I was clueless. I'll "release you" and follow this suggestion.
User 10/12/2016 - 11:59
ty for your help and time
Excelchat Expert 10/12/2016 - 11:59
Thanks for using Live Spreadsheet Help. Please give your kind feedback for our service.Have a good day ahead.
User 10/12/2016 - 11:59
how do i finish this session?
User 11/12/2016 - 12:00
you too
Excelchat Expert 11/12/2016 - 12:00
Sir you can do it by Click on end session button, the red button.
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.