Announcements
cancel
Showing results for
Did you mean:
Contributor III

## AGGR MEASURE VISUALIZATION PROBLEM

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?

1 Solution

Accepted Solutions
MVP

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)

7 Replies
Contributor III
Author

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

MVP

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)

Specialist

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

Ciao,

Luigi

Specialist

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

Contributor III
Author

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

Contributor III
Author

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

Specialist

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