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.
