Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How do I do this?
The question given (show contribution % to sales of each Employee in the dept )
Thank you so much.
LOAD * INLINE [
DeptID, Employee, Price, Quantity
101, Tom, 10, 1
101, Sara, 100, 2
101, Maya, 350, 7
102, Carl, 450, 4
102, Martha, 560, 6
103, Layra, 450, 7
103, Ten, 320, 4
103, Mark, 560,3
];
Just go to Number tab of Straight table and format fixed to 1 decimal place and tick the box show in percent%
Hi, if you have a table with DeptID and Employee as dimensions you can use this expression:
Sum(Price*Quantity)/Sum(TOTAL <DeptID> Price*Quantity)
Thank you Ruben.
But I am not getting it in percent.
Below is the outcome I am suppose to get.
Many Thanks.
Just go to Number tab of Straight table and format fixed to 1 decimal place and tick the box show in percent%
Got it .Thank you so much!
Hi Ruben. I got the answer. Thank you for your help:)