Automating filtered totals

**Andy Pope** · 10-12-2010, 09:40 AM

You maybe able to use a pivot table based on data and some helper columns.

Can you post a example workbook so we can see the real layout of the data.
Also include a few more records is possible.

**flux88** · 10-12-2010, 10:02 AM

I've attached a sample spreadsheet.

Just playing around with Pivot now.

**Andy Pope** · 10-12-2010, 10:11 AM

Try this example pivot table

**flux88** · 10-12-2010, 10:28 AM

Thanks that is exactly what I want.

However when I copy and paste my data and extend to helper cells the pivot chart doesnt update?

**Andy Pope** · 10-12-2010, 10:32 AM

Would not expect it to either.

You need to use the Pivot wizard to step back and adjust the range being used, you can then refresh the table.

You can use a dynamic range as the data source if you set it up.

PTDATA: =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$1:$1))