Hi,
I have 2 dropdowns Region, Country; Pie chart & another spreadsheet.
when the dashboards load…loads All data for regions & country. Pie chart loads. From pie chart i drill down(passing value 1) to populate the data in spreadsheet. it works good till here.
At this point i go & select something else from dropdowns, the pie chart value(1) stays…how can i reset to All(for spreadsheet) when dropdowns are changed.
Any ideas
kraf (BOB member since 2013-06-25)
Hi,
Total you need two combo boxes, two spread sheet components and One pie chart component to achieve your requirement.
Step 1: Enable the data interaction on the pie chart and map it to one row.
Step 2: Uncheck the default selection for Pie chart
Step 3: Use First combo box to drive the spread sheet result set based on the pie selection and it will not have any all as the label and and it works at the backend.
Step 4: In the Second combo box select the lables including All and map the selected value to the destination cell of the pie chart.
Step 5: In the First combo box default value needs to be mapped from destination cell of pire chart(as we know second combo box selection destination also same)
Step 6: In one spread sheet display the filtered result set
Step 7: In one Spread sheet display all the records.
Step 8: write the following forumala to provide the dynamic visibility between the Spread sheets and apply the Dynamic visibility in both the spread sheet components.
=IF(C2="",1,IF(C2=“All”,1,0))
In the above formula C2 cell is the destination cell of second combo box and pie chart selection.
Step 9: After performing all these steps then you can see the required behavior.
Hope this helps.
Regards,
Sampath
sams_d7 
(BOB member since 2007-07-24)
i changed the functionality from drill down(pie chart) to label based menu. I will try to test your sol…thanks
kraf (BOB member since 2013-06-25)