Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a problem.
I am creating a table chart with 3 dimensions , but the expression must be related to only two ( Aggr ) .
In this case the number 14 should repeat for each BANDEIRA/UF iguals because the AGGR is with BANDEIRA and UF .
Expression about TESTE 00: =COUNT({<EAN=,UN_01={'>0'}>} OUTLET_COD)
Expression about % Bandeira / UF: =AGGR(COUNT({<SKU_SELL_OUT=,OUT_ATIVO={'S'}>} CNPJ),OUT_BAND,UF)
My goal is to one another to find out how much each EAN is about the total Flag x UF. But when I do that the graph only shows the first EAN .
TKS
Try this:
Count(TOTAL <OUT_BAND, UF> {<SKU_SELL_OUT=,OUT_ATIVO={'S'}>} CNPJ)
or not recommended:
=Aggr(NODISTINCT Count({<SKU_SELL_OUT=,OUT_ATIVO={'S'}>} CNPJ),OUT_BAND,UF)
Try this:
Count(TOTAL <OUT_BAND, UF> {<SKU_SELL_OUT=,OUT_ATIVO={'S'}>} CNPJ)
or not recommended:
=Aggr(NODISTINCT Count({<SKU_SELL_OUT=,OUT_ATIVO={'S'}>} CNPJ),OUT_BAND,UF)
Perfect
I'm used
Count(TOTAL <OUT_BAND, UF> {<SKU_SELL_OUT=,OUT_ATIVO={'S'}>} CNPJ)