1 Reply Latest reply on Sep 26, 2013 8:03 AM by Matt Lutton

    How to make filter action to work across measures?

    Rama Kunaparaju

      Hi, Please refer to the attached workbook.


      I have a list of measures by month as a data view for the top sheet. The bottom sheet has the same information but as a line graph. I want to link these 2 sheets such that when i click on a measure lets say "budget profit" it should give the line graph for only that below. Can we make a filter action do that? Or is there a work around. I dont want to do a parameter because i want the user to get the line graph right from the top sheet by clicking.