Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)
no it didn't work, now all of the dimensions are =0
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)
Hi Marco, I think you need to add prov_residenza to your AGGR.
Ciao,
Luigi
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
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
Option 1 worked perfectly thanks sunny. How can I mark the question as answered, I',m a rookie in here
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