Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a dashboard contains 2 sheets, sheet 1 contains summary and sheet 2 contains details
for ex: in summary sheet I have a KPI showing employee count which is '4'
in detail sheet I have detail report with all the 'n' number of employee records.
my requirement is, in summary sheet when I click on the employee count KPI(which is 4 Employees), it need to go to the details page and show only those 4 employee records.
how can I achieve this.
any help would be much appreciated.
Thanks!
@sjar1290 You can use button for this requirement, in button you need to create a action and navigation. to do so Please follow below steps
1. Drag & Drop Button into the sheet and add action "Select values matching search criteria"
2. Select your field and in value provide you KPI expression in the format like below
='=Sum([Sales Amount]) > 200000'.
if you have any doubts you can refer below link
3. Now add navigation to the sheet 2. when you click on the button it will navigate to the other sheet.
4. To display the employee count as like KPI, go to button >> general >> label >> expression. Add your expression like below
Employee& Chr(10) & Count(employee)
5. Set font color and back ground color as you desired.
That's it your KPI will be ready and by default it will show the employee count and when you click it will navigate to other and displays those employees only.
Thank you!
@sjar1290 Please accept as a solution, if it is answered your query
Thank you for helping me.