7 Replies Latest reply on Sep 26, 2017 7:47 PM by Dipali Belamkar

    Drilling to Details

    Dipali Belamkar

      Hi All,

       

      I have Created on simple report which shows the # of Met , # of Total and % Actual (Which is Met / Total) in a trend of Weeks as column.

      What i am trying to achieve here is :

      When user click on any value like for e.g 2 ( highlighted wk36 Met) ; they should be able to get 2 records from might be raw data or i am fine with creating another sheet with the field i wish to display. The challenge is how do i filter the data on which user has clicked.

      Note: Met and Total are not the direct filed for raw data. They are calculated fields

       

      Thanks in advance.