1 Reply Latest reply on Dec 28, 2016 9:05 AM by Dan Huff

    Applying Global Filter for Lookup calculated field

    Sravan Yadav

      Hi All,


      I just want to Apply a "Global Filter" for Lookup Calculated Field...Searched in Google but Hardluck..Please find the below Screenshot and .twbx v9.3, for better understanding..global filter.png

      Note- I dont want to apply a parameter in my "sub-category" as there are  many dimension members in sub-category in my original data.



        • 1. Re: Applying Global Filter for Lookup calculated field
          Dan Huff

          Since Lookup is a table calculation, it relies on data in the sheet it is used on. As such, these types of hide filters cannot be used across multiple sheets.


          Can you describe in more detail what you are trying to accomplish? Is there some sort of aggregation you are trying to achieve by hiding these values instead of just filtering them? If so, it may be possible to achieve something with LOD calculations.