2 Replies Latest reply on Nov 21, 2018 5:35 AM by daniel.andell

    Blending data correct

    daniel.andell

      I have two data sheets that I would like to blend togather. First I have the data with sales and Products.

      Second I have a file that tells if the Product is a focus Product or not. So in my example all Products called Toy, Cream or Ice should be filtered as new in my calculation below.

       

      IF ATTR([Product]) = ATTR([New products (New Products)].[Products]) THEN 'New' END

       

      It works fine if I use the Product field in my dashboard

       

      But when I try to show Group only New seems to get lost and move to the null side. I cant figure out how I can be able to use this second sheet with focus Products?

      Hope you can help me out. I have attached an example too.

      data source 1

       

      data source 2