Skip to Content
0
Former Member
Jan 02, 2008 at 04:38 AM

How to have 2 Group Summaries in a same chart?

24 Views

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.....