SUM After Distinct Count

[vijayit43]

Dear All,

In My Qv  we create pivot dimension field is state,DistributorCode,RetailerCode,brand and expression field is count(distinct brand) when we expend brand level then give right answer which we want and when we collapse state level then also distinct count but we want when we collapse state level then distinct count only retailercode level after that it sum that count how to possible please help ..

for refrence attach qv

[preminqlik · Accepted solution]

hi use this exp

hope this helps you

sum(aggr(count (distinct Brand),State,DistributorCode,RetailerCode,Brand))

[jagan]

Hi Vijay,

I think count (distinct RetailerCode) makes sense, you will get the required values.

Regards,

Jagan.