Pivot Table Calculate Two Values at Once

[Slimex]

I want to sum the number of tickets I produce. I also want to sum the number of tickets I discard and show both values at once in one pivot table.

I also want to filter for discarded and not discarded tickets and show the percentage of each--again all in the same pivot table.

I have not been able to do this...is it even possible... Thank you.

 

[danzon]

Can you pls provide sample data .... it should not be a problem but we will need to know the layout of your data to help