Error in expression

[nikhilgarg]

Hello,

I am attachine a qvw. In this i want a column to the right of Client that shows TOTAL of count of Accepted values per client. I tried to do it but error is there.

Thanks

[sunny_talwar · Accepted solution]

You need aggregate function around your Count function in the calculated dimension. May be this:

=Aggr(Count({<State = {'Client-Accept', 'Dealer-Accept', 'Accepted'} , ClientId = {'1', '4', '3'} >}State), Client)

if this is what you want?

[alexandros17]

Here it is