I am preparing a Tableau report from Excel, That data at function, Service Area and Service Line level. My intention is to analyse Attrition % (Which is a division of two measures in the excel file). After I input the data into Tableau, The data is working fine at the lowest level, i.e. Service Line level. But If Drill up the data and try to represent by Service Area or funtion all the percentages are getting added up, How to prevent this?
In the attached picture , the YTD Vol Attrition % = Total Vol. Seperations YTD FY13 / Avg. Active Headcount YTD.