Contribution %

[Lalita_Rai]

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
];

[rubenmarin]

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)

[Lalita_Rai]

Thank you Ruben.

But I am not getting it in percent.

Below is the outcome I am suppose to get.

 Many Thanks.

[Lisa_P · Accepted solution]

Just go to Number tab of Straight table and format fixed to 1 decimal place and tick the box show in percent%

[Lalita_Rai]

Got it .Thank you so much!

[Lalita_Rai]

Hi Ruben. I got the answer. Thank you for your help:)