Problem with aggregation formula (table)

[#1]

Hello

I would like to ask how can I “repeat” the same number , which is an aggregation of total skus per stores, to the entire table.

On my QV I have the following:

Brand        =avg(aggr(count({< Subsegment, Manufacturer, Brand>} EanCode), Store))

A                  226

B                    -

C                    -

And what I really want is this:

Brand        =avg(aggr(count({< Subsegment, Manufacturer, Brand>} EanCode), Store))

A                   226

B                   226

C                   226

Thank you very much beforehand.

[tresesco · Accepted solution]

NODISTINCT keyword.

=avg(aggr( NODISTINCT count({< Subsegment, Manufacturer, Brand>} EanCode), Store))

[PrashantSangle]

Hi,

Try with putting Brand in AGGR()

Like

avg(aggr(count({< Subsegment, Manufacturer, Brand>} EanCode), Store,Brand))

Regards

[#4]

hi

try this

=avg(aggr(nodistinct  count({<Subsegment,Manufacturer,Brand>} EanCode),Store))

[#5]

Thank you very much, it did work perfectly!