Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
BU, DESTINATION and Staff are the dimensions...used in the pivot chart..
Would you be able to share an image of what you are seeing and explain what you would want to see?
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.