1 Reply Latest reply on Feb 6, 2015 12:57 PM by KK Molugu

    how shows not existing dimension measures

    Michal Wrobel

      Hi I have data for examle Customer, Product, value :

      Customer1 - Product1 - 100

      Customer2 - Product2 - 200

      Customer3 - Product3 - 150

      Customer4- Product4 - 160

       

      Now I Put to Rows Customer , to Column Product and Value

       

      And now is question  how shows Custers who not have product3

      I need to shows all customers only product3 and value if I put product3 to filter i only see customers with product3 but i need to see all customers and if not existing Product3 for examle 0

       

      I tray LookUp , Zn function but is not working

       

      Please help

       

      Regards Michal