Agg function Issue

[jjustingkm]

I have an aggregate function like this .

=sum(aggr({$<Region={'NA'}>} count(distinct ID), Gender))

+sum(aggr({$<Region={'SA'}>} count(distinct ID), Gender))

When I use it in the graph against year, it gives correct result if I select a particular year, but gives incorrect result if I dont select any year.

Please help.

[Kushal_Chawda]

@jjustingkm  you need to add year dimension in aggr function

=sum(aggr({$<Region={'NA'}>} count(distinct ID), Gender, Year))

+sum(aggr({$<Region={'SA'}>} count(distinct ID), Gender, Year))