2 Replies Latest reply on Jun 18, 2018 1:42 AM by Emmanouil Paterakis

    Filter

    Emmanouil Paterakis

      Hi all,

       

      I have two sheets on a dashboard which contain products with percentages from total sales. In both of them I have the same filters which are basically calculations.

      I want to be able to use the same filter in my dashboard for both of the sheets but currently I cannot find the option to apply in multiple sheets.

      By doing a quick search I found that this happens because you cannot use table calculations as filters for multiple sheets. The problem is that if

      I use the normal dimension without converting it before I mess up with my percentages of total.

       

      The formula I am using to create the filters is LOOKUP(ATTR([the dimension I wanna use as filter]),0)

       

      Is there any way to do it?

       

      Kr,

      Emmanouil