Dear revered members,
I want to create a dashboard for our Management with drill-down feature. Let's say I have 2 branches. My sales of these 2 branches are reflected as Pie Chart in Dashboard. Now what I want is, when I click on one of the Branches, I need another sales report related to that particular branch only.
There are also many other report which I want to navigate from Dashboard through this drill-down feature.
Is it possible? If yes, can you guide me? Since I am not from programming background but I can write simple SQL queries related to the reports.
Your step-by-step guidance will be much appreciated.
Thanks in advance.