Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am trying to create a gauge chart for one division. I want it to be locked so that when you select other divisions it doesn't change. If possible also locked on max year.
Expression:
rangesum(above(total sum({1<DivisionName = 'XXX'>}RevenueAmount), 0, rowno(Total)))/rangesum(above(total sum({1<DivisionName = 'XXX'>}BudgetAmount), 0, rowno(Total)))
you can use alternate states
Yes I now got the gauge charts just the way i want them. Thanks!
Do you maybe got a clue how i can let them show the last week thats in the system.
Now i have to select the week from 2014 they'll show but is it possible they automatically select the last week?