Distinct Count when collapse

[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

[maxgro]

seems to me you want to sum the distinct brand by state and customer

sum(aggr(count (distinct brand),  state, customer))