AGGR Fuction with SUM Set Analysis

[#1]

Good Morning,

first of all many thanks for your attentions.

I semplify the question:

I have a Table with ACTIVITY,DOCUMENT,MILESTONE,ACTUAL_DATE and PROGRESS

i should calulated in DIMENSION sum of the documents PROGRESS group by ACTIVITY.

the value shouldn't take the filter on job document so i Worte a calculated dimension:

=AGGR(

sum({1}

if(ACTUAL_DATE <=TODAY(),PROGRESS)

)

,ACTIVITY)

and works OK.infact if i select one document the dimension value is 1100 beacuse sum all progress document of the activity

but this is not ok for me because,for the other reasons, i should aggregate also for DOCUMENT and so i wrote:

=AGGR(

sum({1}

aggr(

if(ACTUAL_DATE<=TODAY(),PROGRESS)

DOCUMENT,MILESTONE)

)

,ACTIVITY)

while, in this mode,
the value is 80...seems that if i aggregate for DOCUMENT the {1} not works ok.

[#2]

Brian,

maybe this will be helpful:

Re: Trouble using aggr() for YTD Revenue comparison unless both years are selected

[#3]

many thanks!with only function seems works fine!!