topic Re: AGGR MEASURE VISUALIZATION PROBLEM in App Development

AGGR MEASURE VISUALIZATION PROBLEM

marcoserilio — Wed, 13 Dec 2017 16:40:18 GMT

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?

Re: AGGR MEASURE VISUALIZATION PROBLEM

marcoserilio — Wed, 13 Dec 2017 16:52:40 GMT

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

Re: AGGR MEASURE VISUALIZATION PROBLEM

sunny_talwar — Wed, 13 Dec 2017 17:10:07 GMT

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)

Re: AGGR MEASURE VISUALIZATION PROBLEM

luismadriz — Thu, 14 Dec 2017 05:54:31 GMT

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

Ciao,

Luigi

Re: AGGR MEASURE VISUALIZATION PROBLEM

luismadriz — Thu, 14 Dec 2017 06:16:34 GMT

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

Re: AGGR MEASURE VISUALIZATION PROBLEM

marcoserilio — Thu, 14 Dec 2017 08:48:00 GMT

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

Re: AGGR MEASURE VISUALIZATION PROBLEM

marcoserilio — Thu, 14 Dec 2017 08:49:17 GMT

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

Re: AGGR MEASURE VISUALIZATION PROBLEM

luismadriz — Thu, 14 Dec 2017 22:44:38 GMT

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