Hiya folks!

Heres a challenging one... at least for me it is:

I have a list in a report showing the sales for a specific period... such as the below:

DETAILS SECTION OF REPORT (HIDDEN):

PRODUCT QUANTITY
Hamburger (1 July) 10
Coca Cola (1 July) 20
Ginger Ale (1 July) 15
Hamburger (2 July) 5
Coca Cola (2 July) 6
Ginger Ale (2 July) 11

PRODUCT HEADER SECTON OF THE REPORT (VISIBLE - this shows sales by grouping the products for all dates):

PRODUCT QUANTITY
Hamburger 15
Coca Cola 26
Ginger Ale 26

The problem I am having is the following:

In the PRODUCT FOOTER section of the report, I have created the following function:

=Count([Product])

This gives me the count of products that appear in the DETAIL section of the report... in this case the result is "6".

But what I want it to do is to give me the result of the count of the products in the PRODUCT HEADER section of the report... therefore I should get a result of "3". But I cant seem to get this to work.

Any advice?

Thank you!!!