Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Here is the requirement. whenver I click a dimension in Bar Chart/Pivot table, another chart(Pie chart) should be populated. This shouldbe dynamic.
Org Type | Sector | Company Name | Tax pay |
Govt | Biotechnology | Name1 | |
Infrastructure | Name2 | ||
Medical | Name3 | ||
Manufacturing | Name4 | ||
Private | IT | Name5 | |
Manufacturing | Name6 | ||
Banking | Name7 | ||
Public-Private | Biotechnology | Name8 | |
Infrastructure | Name9 | ||
Medical | Name10 | ||
Manufacturing | Name11 |
Suppose when I selected the dimension 'Org Type' in pivot table/bar chart, a new sheet object(Pie chart) with "Sector" as dimension & "Tax pay" as expression shoud be visible.
Thanks in advance...
Hi
Populating the pie chart when a selection is made is standard QV functionality. If you want to hide the pie chart until something is selected, use a Show condition in Properties | Layout of the pie chart. Use something like
=If(GetSelectedCount([Org Type]) >= 1, 1, 0)
for the condition.
HTH
Jonathan
You should use circular or drill down dimensions. So that when you click on a section of a pie chart or a bar in a bar chart it will drill down to the next level or show any different dimension you want. You can define them in the dimension tab
Thanks Jonathan for the quick reply..
But the the is I have one list box "Org Type". So whenever I selects the value from the list box also the pie chart will be populated... actually that is not the the scenario. ( The pie chart should be populated only when we choose the dimension in bar chart only).
Thanks Adrian..
This approach will work for barchart/pie chart type in some extenent....If we have the data in pivot table then how we can achieve this scenario?
You can also allow the chart to switch between different types (Fast Type Change) on the general tab. It allows the same information to be shown as any of the charts
in this way, we can show case same data in different objects, I think it won't catter my requirement.
Anythoughts from all of you.. it is a liitle bit urgent requirement for me...
Pradeep Taniparthy wrote:
But the the is I have one list box "Org Type". So whenever I selects the value from the list box also the pie chart will be populated... actually that is not the the scenario. ( The pie chart should be populated only when we choose the dimension in bar chart only).
I don't think there is any way to detect how the Org Type was selected. Clicking in the bar chart is functionally the same as selecting one in the list box.
If you don't want the users to make selections in the list box, don't include the list box on the sheet (although I don't know why you would want to do that)
HTH
Jonathan
Actually, I am showcasing summary information in bar/pie chart. Whenever I click on the chart I have to populate the detailed inforamtion in table(Pivot/Straight/General Table) format....