aparvez007 Member Oct 16, 2012 #1 Dear All, Please help me out... how to link Radio button to pivot table dropdown... Thanks Pavi
K kaushik03 Member Oct 16, 2012 #2 Hello Pavi, Can you plz tell us what version of excel you are using? If you use excel 2010, then you can go for slicers which is even a better option.. Kaushik
Hello Pavi, Can you plz tell us what version of excel you are using? If you use excel 2010, then you can go for slicers which is even a better option.. Kaushik
aparvez007 Member Oct 16, 2012 #3 Thanks Kaushik... I m using 2010 but i want to use Radio button. On my main sheet i have 4 radio button which i want to link to pivot. if user click on one of radio button then data should update in below table... Actual i have 4 product so i want one table to show selected product usin radio button. Please help. Regards, Pavi
Thanks Kaushik... I m using 2010 but i want to use Radio button. On my main sheet i have 4 radio button which i want to link to pivot. if user click on one of radio button then data should update in below table... Actual i have 4 product so i want one table to show selected product usin radio button. Please help. Regards, Pavi
K kaushik03 Member Oct 16, 2012 #4 Hi Pavi, Can you plz upload your sample file here in order to help us understand the data layout? http://chandoo.org/forums/topic/posting-a-sample-workbook Kaushik
Hi Pavi, Can you plz upload your sample file here in order to help us understand the data layout? http://chandoo.org/forums/topic/posting-a-sample-workbook Kaushik