9 Replies Latest reply: Jun 9, 2016 4:28 AM by Xandro Lisci RSS

    Dear experts

    Xandro Lisci

      How can I exclude some field names in a dimension. For example: I want to present a graph of a Region consist of Europe, North America, Oceania, Asia, Not Relevant and blanc. I want to exclude Not relevant and blanc. I solved this by the following formular:

      Sum({<APG_REGION_NAME = {"Europe", "North America", "Oceania", "Asia"}>} MARKET_VALUE_APG_BASE)/1000000

       

      But I want to know how to exclude the names Not Relevant and the blanc field

       

      Thanks in advance

       

      Best regards

       

      Xandro