Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Team,
I have one table (Table 1) - say "Department Master" - which has department and sub department names listed.
I have another table (Table 2) containing expenses and sub expenses (eg: Staff expenses - Personnel Expense & Training Expense) for each department + sub department combination.
Now I am showing a trendline of all these expenses over a period of the financial year.
I want 2 drop down lists (1 for department and 1 for sub-department). When I select a department, only then respective sub department drop down should get populated with values.
Also the trendline must display for the selected department (sub-department if selected or total of department if not selected).
Right now, when i created 2 drop down/selector in App OverView section. But all sub departments are getting displayed like a simple list. How to conditionally bring it in and how to use the synthetic key (department name) as a parameter for this?
Thanks & Regards,
Abhiram V
You can try using an expression like aggr([sub-department],[sub-department]) as dimension for the sub-department filter pane. That expression will make sure that only possible values are shown after a selection in the department field is made.