I am new to tableau & having data in the form of the below input dataset.
COMPANY Id,Name,Month,Salary
1,SAM,AUG,10000
1,JOHN,JUL,20000
1,JACK,AUG,30000
2,TOM,AUG,20000
I need output in the below form
COMPANY ID, MONTH, MONTHLY SALARY, TOTAL SALARY,PERCENTAGE
1, AUG,40000,60000,66%
1, JUL,20000,60000,33%
I am able to calculate the Monthly salary & Percentage. But I am not able to find the grant total of salary. It is giving Monthly salary only there as well. I used below formula in calculated field but it doesn't work. Can you please help me
SUM(IF [COMPANY_ID] = '1' THEN SALARY ELSE 0 END)
