Hi all,
I have been asked to create a report studio report with a bar graph with a bit of trick in it. I have been asked to plot the sales % and order % based on the budget in the graph, as attached in here. However the tricky part is,
1. To manipulate the palette value label. If the sales is over the budget the graph needs to plot only upto 100% but the value (pallette -> show values ) needs to be its real value. If the sales% is 586% against the budget the graph needs to stop plotting at 586% but the value label needs to be 586%. see the item marked as 1 in the attached screen shot, where it is showing as 586% , but it renders for 100% only ad the rest of that palette is stripped off. I can manage the stripping off of this data item by some if statements (if it is over 100%, then make to 100%, otherwise show the actual % ) , but the hard part is to show the palette label as 586%. Any body have any suggestion, java script or any nice tips
2. Item 2 in the screen shot is the month bar on top of the graph and it is a separate fixed table with the month names plotted in it. No relation ship with the graph at all
3. I want to provide a marker on the graph based on the current month and any body have any idea, how to do this.
Thank you in advance