1 of 1 people found this helpful
Firstly, I would create a calculated field to count the number of fields which are 'not assigned' i.e. [Count Not Assigned] =
COUNT(IF length = 'not assigned' then [Material] end + IF [width] = 'not assigned] then [Material] end + .............. continue the logic for each field).
Then you will be able to calculate % completed with an new field as;
[Count Not Assigned] / 6
For the 'drill down' your best bet will probably be to setup a Dashboard with two sheets;
Sheet one (at the top) would be a summary sheet with each material and the % completed.
Sheet two (below) would contain one row per material with the detail columns.
When you click a row in Sheet 1, the action filter will filter on Sheet two below using Action Filters. See this KB Article - Creating Filters with Actions on Dashboards | Tableau Software
I haven't tried this approach yet, I will give it a shot!