mattster1010
01-06-2011, 07:13 AM
Afternoon Everyone,
I am creating a report in excel using subtotals to total the cost of each account. This works fine.
I'm then applying an advanced filter on the cost column (K) to show records above 250 (>250). The advance filter returns all individual records that qualify for this criteria. However, is there anyway that the advanced filter can look at the subtotals of each account and filter the records using the overall total?
I have uploaded a sample of my data.
Regards,
Matt
I am creating a report in excel using subtotals to total the cost of each account. This works fine.
I'm then applying an advanced filter on the cost column (K) to show records above 250 (>250). The advance filter returns all individual records that qualify for this criteria. However, is there anyway that the advanced filter can look at the subtotals of each account and filter the records using the overall total?
I have uploaded a sample of my data.
Regards,
Matt