Aggr as a measure

[kprotrka]

I have one problem. Ia using following calculation:

aggr(Zeitaufwand,id_u3)

When is it like dimension it shows correct results.

As a measure is showing wrong results.

Last column is what i would like to get and column before is as a measure. I need to show it as a measure in bar chart.

[Anil_Babu_Samineni]

It's clearly stating that this dimension "id_u3" is having aggregate data, So to get accurate data you have to aggregate with this field as well?

aggr(Zeitaufwand,id_u3, budget_applied_date1)

[kprotrka]

No,still get only one row....

[Anil_Babu_Samineni]

Can we have a sample QVW to work? Aggregate will always give one row based on row level. 

[kprotrka]

Here my code....first thing is what i need to get this thing for each row.

[Anil_Babu_Samineni]

Which sheet and report I should look? 

[kprotrka]

I found one solution...i did left join and grouped column zeitaufwand per projektnummer....

Thanks 🙂