This content has been marked as final. Show 2 replies
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