Max limits in gauge trellis charts

[#1]

Hi,

I've set up a trellis chart of 3 gauges, one for each department and I need to show how each is performing against the Sum(Budgets) for each separate department.

How can I effectively have a different max value generated for each department?

Hope this makes sense.

Thanks in advance,

Robin

[goldnejea8]

Try having an If..Then statement in the max value field. 

If(department='A', 3,

     If(department='B',4,

          If(department='C',5')))

[SunilChauhan]

in max Value

Sum(Budgets)* 1.2( taking 20% extra of sum)

hope this helps

[#4]

Thanks Sunil and Josh, but this won't work for me because the Sum(Budgets) gives me the combined total for every department (i.e. the entire company) whereas I need the each gauge to recognise which dimension (department) it relates to and then only calculate its max value as the budget for that single department.

Sorry if I didn't make this clear in the original post.

[#5 · Accepted solution]

Sorted.

I just changed my expression to show the percentage of budget met and this has worked OK.