Aggr Issue With Hierarchy Level

[dineshm030]

Hi All,

While creating the table chart with hierarchy level, am facing the issue with AGGR function. When I select the One AMName, last field value % is showing correctly as 71.4%. (Eg. Sayed Asif Iqbal).

Eg. Samir Kazi (50%) (3/6)

Without selection it is taking overall count for all AMName (87/124). Without AMName selection it should show 71.4 % (5/7). Below is the expression using:

Count(total distinct AMCoachingSystemUserId)/Count(total distinct [%_SystemUserId])

Kindly help me out.

Thanks in advance.

Regards,

Dinesh Kumar Mani.

[MayilVahanan · Accepted solution]

Hi

Count is based on AMName? If so, try like below

Count(total<AMName> distinct AMCoachingSystemUserId)/Count(total<AMName> distinct [%_SystemUserId])