Dynamic dashboard

[Ratan Bhushan]

Hi Friends
I am making a Dashboard for my file. I am uploading where I need result like the PIVOTS made in the file. But I want result dynamically. Please help me to achive it, and requesting you to reply if I am not understood.
Thanks alot

 

[Nebu]

Hi:
Please find the attached...

 

[Ratan Bhushan]

Hi:
Please find the attached...

Hey buddy

How did you achieve this thing? Please to help me to understand this
Its my request

 

[Nebu]

I have achieved it using match function to identify the rows from the pivots and used offset functions to selective the respective rows and columns based on the drop down selection, the indirect function is to make the the reference for the offset function dynamic...