Sum a group total.
I have created groups, some have totals and some don’t
Etc
North Sector Group
GP1 1
GP2 0
GP3 13
South Sector Croup
GP1 0
GP2 2
What I’m after is a result something like this:
North Sector Group - 3 Areas, 2 Areas >0 , 14 items
South Sector Group – 2 areas, 1 Area >0, 2 items.
I cannot do a simple sum as each group has many values which I sum up to give the group total. I’ve tried “if GP>0 then 1 else 0” – but I cannot then sum this up further on...
Effectively the bit I’m falling over on is to get a count of the groups where Items are > 0
IP Logged