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.
Hi,
How about
total( count( distinct product-id for productline, product type ))
Does this give you a single count total?
MF.