Pivot Table Column Filtering

[Tpeter201811]

Hello,

I am trying to create a stacked column chart that will show for each name, the amount of times a specific code shows up

ex data. Name Code
Joe -----123
Bill ------345
Sarah----123
Bill ------123
Joe------345

and the graph would show 3 column with joe's and bill's haveing a second "stack" with a value of 1 for each bar and sarahs showing only one bar

I already have my source data in a pivot table and 3 columns of the (count of the name), as I have 3 codes I would like to show......

My problem is I cannot find a way to filter each of these columns seperately using the same criteria (the code column of the database as my filter)
I want to have my pivot header look like...

[TABLE="width: 704"]
<TBODY>[TR]
[TD]Coding (filter) </SPAN>
[/TD]
[TD]123
[/TD]
[TD]456
[/TD]
[TD]789
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Values
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row Labels
[/TD]
[TD]Count of Name
[/TD]
[TD]Count of Name
[/TD]
[TD]Count of Name
[/TD]
[/TR]
</TBODY>[/TABLE]

Person1
Person2
Person3



right now only one of the BOLD filters is applied and I need the others...

Where basically the same filter type, (coding), is applied but filtered for a different "code" in each column....

Is there a way to do this??? Thanks.

 

[Andrew Poulsom]

Put Name in the row field, code in the column field and count of name in the data field.

 

[Tpeter201811]

Thank you sir, both for a correct solution and a fast response!!! Worked great!!!