Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, We have one dashboard where we have default parameters Year is set to current and last year (2022,2021).
We have one bar chart to show top 10 revenue and another chart to show revenue against Months, another chart with salesperson. All working fine.
Requirement is now changed, we need to show top 10 revenue for last month only as fixed and other chart should show as per default year selection dynamic.
If user selects the revenue bar, then next two chart should show all details linked to that revenue.
Basically user want to see the previous trend of top revenue generator's of last month.
It may be easy stuff for experts, i am new. Thanks in advance for your help with some code scripts.
=sum({<revenue= {"=rank(sum(revenue))<=10"},Month={=max(monrth)-1}>}revenue)