Thread: Multiple filtered columns in a pivot table

Hi all,

I need to create a Pivot table with three columns.

The first gives a location (noted in a column in the original data), the second the amount of rows in the original data that is registered against that location and the third is the amount of rows registered against the location after applying a filter to another column.

I've attached an example which will hopefully make this a bit more clear.

Thanks for your help!

Jo

Originally Posted by donaldsmith1978

where you enter your budget amounts and track your actual expenses, including payment cards and credit cards. At the end of the month, review your cash and credit card spending in pivot tables showing the monthly totals.

In the second pivot table, you can keep track of your balance

Bob also built a pivot table, which compares the actual amounts of budgetary amounts.

I think you may have replied to the wrong thread! Thanks anyway donaldsmith1978