Aggregate measure ignore field dimension under aggr dimension

[adamjiawen]

Hi Everyone,

I have a question about

dimension + calculated dimension, expression

but I hope the expression ignore the dimension to calculate the total.

for example the dimension is product, the calculated dimension the hospitals group by the accumulated market share

the expression would be total of each calculated dimnsion.

Below is my calculated dimension

=Aggr(
If(RANGESUM(ABOVE(SUM({<TIME_CAT = {'CY'},DIM_TIME_CMP = {$(=_V_AUTO_CUR)}>} MEASURE)/SUM({<TIME_CAT = {'CY'},DIM_TIME_CMP = {$(=_V_AUTO_CUR)}>} TOTAL MEASURE),0,ROWNO()))<=0.1, 'D01',
IF(RANGESUM(ABOVE(SUM({<TIME_CAT = {'CY'},DIM_TIME_CMP = {$(=_V_AUTO_CUR)}>} MEASURE)/SUM({<TIME_CAT = {'CY'},DIM_TIME_CMP = {$(=_V_AUTO_CUR)}>} TOTAL MEASURE),0,ROWNO()))<=0.2, 'D02',
IF(RANGESUM(ABOVE(SUM({<TIME_CAT = {'CY'},DIM_TIME_CMP = {$(=_V_AUTO_CUR)}>} MEASURE)/SUM({<TIME_CAT = {'CY'},DIM_TIME_CMP = {$(=_V_AUTO_CUR)}>} TOTAL MEASURE),0,ROWNO()))<=0.3, 'D03',
IF(RANGESUM(ABOVE(SUM({<TIME_CAT = {'CY'},DIM_TIME_CMP = {$(=_V_AUTO_CUR)}>} MEASURE)/SUM({<TIME_CAT = {'CY'},DIM_TIME_CMP = {$(=_V_AUTO_CUR)}>} TOTAL MEASURE),0,ROWNO()))<=0.4, 'D04',
IF(RANGESUM(ABOVE(SUM({<TIME_CAT = {'CY'},DIM_TIME_CMP = {$(=_V_AUTO_CUR)}>} MEASURE)/SUM({<TIME_CAT = {'CY'},DIM_TIME_CMP = {$(=_V_AUTO_CUR)}>} TOTAL MEASURE),0,ROWNO()))<=0.5, 'D05',
IF(RANGESUM(ABOVE(SUM({<TIME_CAT = {'CY'},DIM_TIME_CMP = {$(=_V_AUTO_CUR)}>} MEASURE)/SUM({<TIME_CAT = {'CY'},DIM_TIME_CMP = {$(=_V_AUTO_CUR)}>} TOTAL MEASURE),0,ROWNO()))<=0.6, 'D06',
IF(RANGESUM(ABOVE(SUM({<TIME_CAT = {'CY'},DIM_TIME_CMP = {$(=_V_AUTO_CUR)}>} MEASURE)/SUM({<TIME_CAT = {'CY'},DIM_TIME_CMP = {$(=_V_AUTO_CUR)}>} TOTAL MEASURE),0,ROWNO()))<=0.7, 'D07',
IF(RANGESUM(ABOVE(SUM({<TIME_CAT = {'CY'},DIM_TIME_CMP = {$(=_V_AUTO_CUR)}>} MEASURE)/SUM({<TIME_CAT = {'CY'},DIM_TIME_CMP = {$(=_V_AUTO_CUR)}>} TOTAL MEASURE),0,ROWNO()))<=0.8, 'D08',
IF(RANGESUM(ABOVE(SUM({<TIME_CAT = {'CY'},DIM_TIME_CMP = {$(=_V_AUTO_CUR)}>} MEASURE)/SUM({<TIME_CAT = {'CY'},DIM_TIME_CMP = {$(=_V_AUTO_CUR)}>} TOTAL MEASURE),0,ROWNO()))<=0.9, 'D09','D10'

)

)

)
)
)
)
)
)
),

(HOSP_NAME_CN,(=SUM({<TIME_CAT = {'CY'},DIM_TIME_CMP = {$(=_V_AUTO_CUR)}>} MEASURE),Desc))

)

[Brett_Bleess]

I believe an example application would be better than just the calculated dimension here, so folks can see exactly what you are doing, if you are still trying to sort things, that is what I would recommend to see if someone can then have a look and provide some further guidance for you.

Regards,
Brett