Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
NODISTINCT keyword.
=avg(aggr( NODISTINCT count({< Subsegment, Manufacturer, Brand>} EanCode), Store))
NODISTINCT keyword.
=avg(aggr( NODISTINCT count({< Subsegment, Manufacturer, Brand>} EanCode), Store))
Hi,
Try with putting Brand in AGGR()
Like
avg(aggr(count({< Subsegment, Manufacturer, Brand>} EanCode), Store,Brand))
Regards
hi
try this
=avg(aggr(nodistinct count({<Subsegment,Manufacturer,Brand>} EanCode),Store))
Thank you very much, it did work perfectly!