Find my approach as reference below and stored in attached workbook version 9.3
a. Define Category based on Group functionality
B. Drag Category to the Rows and hide Header
C. Define Action
Dummay.twbx 650.6 KB
Hi Norbert, thank you for the reply.
Drill is not working know. and i should add 3 drill downs to main view Summary view.
first 3(A1c,ACE_ARB,BPP)categories i should have one drill down and
other 3 (CH_Pne,COP_NS,COP_pne_Vac) one drill down
and for rest i should have one more drill down.
Thats why i created 3 drill downs in the tableau work book in the fiest.
Thanks for feedback. Not sure what you exactly are aiming for then...
Okay i will explain again.
He i will have one Text table like below.
if i click on measure Met or Not Met or Totals, i should go to drill down.
3 Drill downs i should have.
One for Categories A1c, ACE_ARB, BPP
and One more for CH_Pne, COP_NS, COP_pne_Vac
and 3rd one one for D_Metfor, D_Pne_Vacc, DWR.
Because i will have difference columns in Different drills downs respective the Category.
If i drill down and going to the drill, the count(Number) on the summary view and drill down Member count should match. now count is not matching.
I hope i am clear now.
As mentioned validating the defined calculated fields "Met" , "Not met" and Totals would be my next step