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


    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?