Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart which displays both the sales and the budget figures. What I want to do here is if a particular date is selected then the sales should change but the budget figures shouldn't change. I can't achieve this using the following set analysis expression.
//Sum({<DateID=>}BudgetValue)
I have attached the file. Can you kindly help?
Regardless of whether a sale has happened or not the budget value set should still come out in the chart. That is the requirement.
Thanks,
Ram
Hi Ramkumar,
I try your set analysis and it working fine Sum({<DateID=>}BudgetValue). Please check it again.
Regards,
Sokkorn
Hi Ram,
This expression is working, even if you select DateID, the budget won't change because we are excluding the selections. Please come up with example if not clear
=Sum({<DateID=>}BudgetValue)
Regards,
Jagan.