Calculations in different dimensions of the visible

[#1]

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

[sunny_talwar · Accepted solution]

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)

[#3]

Perfect

I'm used

Count(TOTAL <OUT_BAND, UF> {<SKU_SELL_OUT=,OUT_ATIVO={'S'}>} CNPJ)