Pivot table - Show values as - question

[vemix]

Hi guys,

Is it possible to break the link between Column Labels and Values ?

What I mean is, if Column Labels are days in a month then we will have 30 or 31 different columns showing. This case would be true if we have only one Value chosen to be in "Values" pivot box. If we have two "Values" chosen then we will have 60 or 62 column in pivot table.

My problem is that I want to view one "Values" as a % of column per Column Label, and the second "Value" show only as a Count of total.

I attached the sheet where it might be more clearly visible.

Yellow columns - I don't want to see
Green column - is I want to see
Blue column - I could alternatively have blue column showing the green one. That's also fine

Cheapest solution would be to hide yellow columns, but I don't want to do it.

Help appreciated.

[judgeh59]

Is this what you are looking for?

[vemix]

Thanks for reply.

No, that's not what I want to see. Column highlighted in yellow I don't want to include in the pivot table. From your example columns H, J and L I want to exclude from pivot table - I only want to see the total count. How do I do that ? I don't want to simply hide the columns...

Thanks,

[judgeh59]

If I understand this correctly you can just remove the Count columns....see example...