Sorting in dynarange from two different cubes

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • Sorting in dynarange from two different cubes

    In my report I am taking Item as dynarange and the data comes from two cube- Stock on hand from one cube and Forecast numbers for the item from another cube.
    I want all those item that have Stock on hand+forecast>0.
    In Data tab for item dynarange if I select Stock on hand cube and do slice operator as <>0 then only those items come who have stock on hand not equal to zero but I also want those items that have forecast not equal to zero. How can I get this sorting from other cube too?