Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sorted.
I just changed my expression to show the percentage of budget met and this has worked OK.
Try having an If..Then statement in the max value field.
If(department='A', 3,
If(department='B',4,
If(department='C',5')))
in max Value
Sum(Budgets)* 1.2( taking 20% extra of sum)
hope this helps
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.
Sorted.
I just changed my expression to show the percentage of budget met and this has worked OK.