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.
