Sheet 1: Priority wise Ticket.
Sheet 2 :Total tickets
Sheet 3:Critical ticket(only P0 and P1)
Sheet 1: Ticket wise details(ticketid,opendate,closed date,status,etc.)
now In dashboard 1,if we select any perticular priority in sheet 1 then the action will be only effect on sheet 2 not sheet 3.if we select any perticular priority(sheet 1) then total tickets for perticular priority else all will be shown in sheet 2 .
now after selecting the ticket count in sheet 2 of Dashboard 1 that will go to sheet 1 of dashboard 2 and will show respective tickets details.
we can't take priority as global filter.(in dashboard 1 priority filter will be effected only from sheet 1 to sheet2 ).
we can't use priority in row,column,level of details,color (in sheet 2 of dashboard 1)because text will be overlapped for all tickets(no priority is selected in sheet 1 of dashboard 1).
we have to pass priority from sheet 2 (dashboard 1) to sheet 1 (dashboard 2).
Plz give some light on the mentioned scenario.
Thanks and regards,
In Dashboard 1 ,click square of P1 priority.Now in total ticket 4 tickets will be shown . Now after clicking on 4 in "Total tickets" that will go to Dashboard 2.but in dashboard 2 only details for those 4 ticket should be shown. But the problem is details for all tickets is showing.
I have attached a sample workbook .
Did u get the scenario and requirment.?