problem with summing the rows

[#1]

my scenario i am having

salesman and manager level charts

in the both charts i am using the same expressions but in the salesman chart

the fields are like area,area num, salesman and in manager level   chart 1

area, region, manager    chart 2

here actually when i sue expression total in the total field the totals are wrong then i changed it to sum of rows then the total are true

but in the the chart 2 there is only one row it is giving me the result as per the expression

isthere any other way to write the expression

RangeSum((sum({<Week={12}>}Vol)/2),sum({<Week={12}>}DISTINCT Units)/2)

[#2]

thanq very much now it is calculating according to the repname and i am getting correct values

[#3]

hi anjos

i am able to fix one issue but when i try to use the same formula for my line graph i am unable to get the correct values RangeSum((sum(VolUnits)/2) , sum(aggr(sum(DISTINCT CB_Units)/DailyDoseConvFactor,RepName)))

and the graph dimension is weekdate

can you please help me on this

[Clever_Anjos]

Try

sum(aggr(sum({<WeekDate={41530}>}distinct CB_Units)/DailyDoseConvFactor,WeekDate,RepName)) or

sum(aggr(sum({<WeekDate={41530}>}distinct CB_Units)/DailyDoseConvFactor,RepName,WeekDate))

[#5]

thanq very much it works perfectly