Issue in expression with aggr

[Anonymous]

Hello Friends

I am using below expression in a Pivot chart , which divides Sale Amount by Count of staff to get Sale per staff.

However the entire total amount displays for each of the staff. Am I doing some mistake?

Kindly help.

[Sum(SALE_AMT)]   / aggr(count(Staff),BU,DESTINATION)

Thanks & Regards

Chintan Gala

[Anonymous]

BU, DESTINATION and Staff are the dimensions...used in the   pivot chart..

[sunny_talwar]

Would you be able to share an image of what you are seeing and explain what you would want to see?

[Anonymous]

Hello Sunny

I have attached the screenshot.

Eg: for Europe there are 11 staff..

I need last column as  second last column / 11.

ie: 0.85/11 = 0.07.....

Dimensons are , Type (not visible in screenshot) , Destination , Staff Name.

Remaining are measures.