HI,
I'm using Web Intelligence Rich Client.
I have 3 Line graphs filtered by an Input Control of 5 sales people: (for example)1-5
Category Axis: Month
Value Axis: Sales
Divided by 3 separate graphs for regions A B and C

Problem: I created a fixed Value Variable ("=[vMaxLineGraph]") for each graphs's Value Axis's Maximum Value. So that tall 3 Graphs display the same Axis height.
When I filter on each Sales person in the Input Control, the Maximum value stays the same when filtering on other sales people, which causes the line graph to drop significantly when the sales figures is alot lower than Sales person 1. Cant see trends.
Question: What formula is useful to set a Maximum value Axis Range for each sales person selected so that the line graphs (A-C) displays the maximum value axis range for each Sales person?