How to Dynamically Explode a Pie Slice
I'm scratching my head on this one. I'm building a report for a Line of Business (LOB) and want to include a Pie chart that explodes the LOB against the entire Companies other LOBs. The Pie chart is built off of the "TOTAL CORP" data set described below, however most of the report lives in the "MAIN LOB" data set.
<MAIN LOB>
<NAME>LOB 1 Name</NAME>
<LOB FINS>
<Total Funding> 123</Total Funding>
</LOB FINS>
<LOTS O OTHER STUFF>
<STUFF/>
</LOTS O OTHER STUFF>
</MAIN LOB>
<TOTAL CORP>
<LOB1>
<NAME>LOB 1 Name</NAME>
<TOTAL FUNDING>123</TOTAL FUNDING>
</LOB1>
<LOB2>
<NAME>LOB 2 Name</NAME>