Counting in reportstudio

[ranne_78]

Hi All

I have  dataitems productline,product type, product id.

I need to get unique count of product id for product type and product line in single dataitem.
In my report we don't want to show product line and producttype.
We need to show the count for unique combination of product-id for productline and product type.

I have only three items in my list report  those are State
                      location
                       Combination  of product-id     

This is very urgent requirement for us.
I used count ( distinct product-id for productline,product type) but I am not getting total value but aim getting count for prodduct line and product type in two separate rows like the following

State  Location   Count
OH      Kent        199
                    444   
-----------------------------
                    643 
but i need get as follows
State  Location   Count
OH      Kent        643

Any one please help me how to achieve this.

[MFGF]

Hi,

How about

total( count( distinct product-id for productline, product type ))

Does this give you a single count total?

MF.