AGGR MEASURE VISUALIZATION PROBLEM

[marcoserilio]

Hi I'm trying with no success to make the following master measure visible in all rows of a pivot table

(aggr(sum({1<segmento = -{'ATV','TRICARRI','QUADRICICLI'}> }  Quantity),  agente,regione))

The output of the measure is correct, but is not visible in all rows, only the first one, see attached image

Under the lombardia dimensios we've got 12 Prov_residenza dimensions, but only on the first row the measure is visible.

Any idea?

[marcoserilio]

no it didn't work, now all of the dimensions are =0

[sunny_talwar · Accepted solution]

Two options

1) Aggr(NODISTINCT Sum({1<segmento = -{'ATV','TRICARRI','QUADRICICLI'}>} Quantity), agente, regione)

2) Sum(TOTAL <agente, regione>{1<segmento = -{'ATV','TRICARRI','QUADRICICLI'}> } Quantity)

[luismadriz]

Hi Marco, I think you need to add prov_residenza to your AGGR.

Ciao,

Luigi

[luismadriz]

Now that I think about it, if you're in a pivot table, you may not need the AGGR,

Just use Sum( {<segmento = -{'ATV','TRICARRI','QUADRICICLI'}> } Quantity)

Cheers

Luis

[marcoserilio]

Hi Luis, that would not suit to my purpose, which is to have a previous level dimension:

I want to see regione's registration units into prov. residenza dimension.

If i added prov residenza I'll get prov residenza registration

[marcoserilio]

Option 1 worked perfectly thanks sunny. How can I mark the question as answered, I',m a rookie in here

[luismadriz]

Thanks for explaining Marco,

So you wanted, for example, the number 32281 for Lombardia repeated for each prov_residenza in Lombardia? and of course that's why you called it Tot Regione?

Cheers,

Luis