cancel
Showing results for 
Search instead for 
Did you mean: 

How to make charts work properly with hierarchical grouping

Former Member
0 Kudos

I have a report that is hierarchically grouped - it represents business objects (i.e., business division, segment, service offering, etc...). It also has details associated with each business object. I was able to summarize "counts" for each hierarchal level but was not able to create charts for the same.

The question is - how do I create a chart that uses summarized data from a hierarchical grouping structure? Do I need to create some sort of programmatic array that is reset based upon hiearchy level? What is the best approach?

Best regards....

Edited by: Donald Scott on Nov 17, 2008 10:38 PM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Donald,

Where you have placed group summrized fields ? I think those fields are related group footer. Place a chart on each group footer and choose the summrized field in your chart.

Thanks,

Sastry

Former Member
0 Kudos

Sastry,

I have placed the chart in each of the groups, but I'm still unable to select summarized fields in the options while creating the x and y axis. Is there anyway to place a chart in a group header and select the summarized hierarchical group data? Or is there a way to build a formula that will count data for details and store the data in a field that is accessible to the chart. In short - it would appear that it is impossible to effectively use charts in a hierarchical groped report - do you think this is the case?

Thanks,

Don

Answers (0)