Hello, trying to solve a seemingly simple, yet very difficult (at least for me) puzzle. Lets say I create a very simple Pie chart with exploding slices, and populate it with Revenue for measure, and product line for pie slices. What I want to do is dynamically blow up a slice with the smallest revenue.
The calculation to blow up slice with an expression is a layout calculation which does not give me ability to calculate min value. If I calculate the min value in another query, Report Studio complains that I need to "reference" that calculation via Properties, which are not there for the Pie Chart.
Any idea how I can solve this puzzle?
Thanks in advance!
This is something of a guess, but select the data item in "Series" in your graph. Now under Properties, you'll find a property called "Properties". (Yes it's confusing.) Open that. You should see your calculated item in the list. Check it, then click OK.