Count using two dimension fields

[rxp03570]

Hi All,

I'm trying to get the Count of Products but I would need to aggregate it with Date and Account ID fields - is the below expression correct?

Count(Aggr(Count(Products),Date,Account_ID)Products).

Can anyone please help with the expression.

Thanks,

Rahul

[Lauri]

Change to this for the correct syntax:

Count(Aggr(Count(Products),Date,Account_ID))

But I'm not sure if this gets you useful data. It's basically the count of different values of Date and Account_ID. Do you need the count of Products for each Date and Account_ID?

[rxp03570]

Hi Lauri,

Yes, I would require Count of products for each date and acc_id.