Post Author: maximus85
CA Forum: Charts and Graphs
hi..
i'm facing this problem.... I have two Summary that i wanted to show on the bar chart with Months as its dimension on x-axis....
The two fields that i Group Summarized are Actual Revenue and Targeted Sales.
This is my problem now....when i have this 2 group sum, i can only select one inside the Chart Expert Data section..... I need to enable the user to click on the Bar Chart(Actual Revenue Field) to drill down for details while at the same time also have the Targeted Sales as a Line Chart.... both in the same chart.... Basically i just wanted to drill down to the Month level to see the details for that month....
Currently i only have Bar Chart which is the Actual Revenue Field inside the chart that can be drill down accordingly by Months.....but i also need the Line Chart(Targeted Sales) to be display as well.....
Thanks and Please Help me Out.....