Break Calcs Lost When Table Becomes Chart

building reports desktopintelligence
1

In my report I have a simple table that calculates Percentage of total revenue by country. The table has a break applied to perform this calculation by year. In the table the Percentage calculation correctly reflects each country’s percentage of the given years revenue but when I turn the table into a chart (stacked column) the values for each yearly column reflect the country’s revenue for that year as a percentage of revenue for all years in aggregate not just for the year represented in the column.

The chart has Year as the Category Axis, Percent as the Value Axis and Country as the Region Color.

Is there a way to retain the table’s break logic within the chart so that each yearly column shows each country’s percentage of revenue for that year only?

Regards

bizintelpro :us: (BOB member since 2013-12-11)

2

Although a solution has not been offered I see that my question has had a decent number of views so I’ll post my current workaround.

  1. I saved the table with breaks in place from BO to Excel which renders the percentage calculations as values thus eliminating the dynamic nature of the percentages that is seen in BO. Before exporting I removed the break footers so that each break iteration flows together as a homogenous table (i.e., no sub-total lines appear as records).

  2. I pull the excel file as a data provider back into BO and then create the graphs.

This works but introduces a number of steps to a process that should ideally be 100% contained within a single BO document.

bizintelpro :us: (BOB member since 2013-12-11)