Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey
Newbie here.
I'm trying to compare budget vs actual by creating a simple bar chart. I also wanted to add an input box to allow some user interaction...
For example,user can type in 10% and it will return all clients with variance greater than 10%.
Please see attachment.
Thanks in advance.
Dorothy
Sorry, accidentally clicked on the status..
Still need help...
Instead of client use, calculated dimension and tick suppress when value is null
=IF(Aggr((Charged-Budget)/Budget,Client)>vPer,Client)
Expression is OK same as your have used...