I have one table in that Category, ID, Taker1, Taker1 Status Taker2, Taker2 Status, Taker3, Taker3 Status is there. Taker1 status, Taker2 status, Taker3 status is completed then overall status is 'complete' otherwise incomplete.
I want to create a new field called Taker1 instead of Taker1, Taker2, Taker3. For this i created resident table and addded that table to main table (Please check the data model).
i created one group (Category --> overall completion --> Taker). Now i want create one barchart with count (ID) using this group as dimension.
i want to drill down the data, first it should be category wise Count(ID) if i click on the particular category bar it should show how many completed and
incompleted ID's and if i click on incomplete it should show Taker wise incompleted ID's.
If i click on incomplete then it should show Taker wise incomplete status (Here one status contains multiple Takers means if Taker1 status is completed and Taker2 status Incomplete and Taker3 status is incomplete then it should show two Takers)
For Example for Category = C, Taker1(Robert) status is complete and remaining incomplete so if i click on category then it should go to incomplete then it should show these two incomplete Taker names(vim, raj) here
i want to show the values based on drill down, Could you please somebody take alook into this and give me some suggestion.
