I am trying to Show dial Guage for Actual vs Budget Cost.
As it is a Cost ,
For sale its easy but for cost the dial guge should be revearsed.
Solved! Go to Solution.
For dial Guage, here is video for your reference.
To get more advice, please illustrate your scenario with more details, please share sample data and desired result.
I am trying to show Cost instead of Sale on Dial Guage,
Cost Budget is $100.
Its a complete opposite scenario then Sales.
No if my Actual cost is $120 with $100 budget then Guage should show Green Area from $0-90, yellow $91-110 , Red for above $110. And the pointer should be in Red area. In the Image below the green area and red area should be switched and pointer should saty in same position but Red because Actual cost exceeded the Budget.