Filters and Group

[CookieMonster76]

Hi

I have a report i run, which has a header row, which totals the (say) 5 rows underneath, before a new header totalling the next (say) 3 rows. Each section is grouped so initially only shows the TOTAL rows, but can be ungrouped to show the lines which make up the totals.

Cole C has a formula to say "show" if Col B is not zero, and "Hide" if it is is zero, but when I apply the grouping it removes that filter, so that when I ungroup it again it shows everything. Is there a way so that when I ungroup it only shows the rows which say "Show" in Col C (Either dierectly or applying some code somewhere)?

ColA Col B Col C

TOTAL 1 100
A 20 Show
B 40 Show
C - Hide
D 40 Show
E - Hide
TOTAL 2 50
F 40 Show
G - Hide
H 10 Show

Thanks

Paul

 

[vw412]

What version of Excel are you using?

How do you perform the "group/ungroup" functions?

How do you determine what rows make up the Totals rows?