Hi MashZone Team
I have follwoing table structure in excel spreadsheet.
Name laborcategory projectname hours deptname
----------------------------------------------
john fulltime project1 8 dept1
john fulltime project2 10 dept1
Mark contractor project1 8 dept1
Mark contractor project2 10 dept1
Paul fulltime project1 8 dept1
Paul fulltime project2 10 dept1
I have been working on different charts on this data but there is one need where i need to show %contractor vs % fulltime for deptment in PieChart. For this example , it would be
2 full time and 3 contracts in dept 1 (66% FTE vs 33% Contractor). How do i do it?
Please help.
Thanks.