8 Replies Latest reply: Nov 30, 2017 12:29 PM by Russell Glenn RSS

    Combining two set modifiers correctly.

    Russell Glenn

      Hello everyone,

       

      I am attempting to combine a couple different set modifiers. I am having trouble bringing them both together to work. Currently, we have data to support the months of September and October. I would like to create a set modifier that also removes certain Product Lines. I am currently using:

       

       

      sum({$<[wProduct Line]=-{"Apples","Oranges"}>} wRevenue)

       

      This is for the product line exclusions.

       

       

      I am also using

       

      sum({<wMonth={"$(=MaxString(Date#(Month,'MMM')))"}>}wRevenue)

       

      This is so the Revenue defaults to view the latest month.

       

      How can I combine both of these in order to see the latest month without filters and the product lines excluding the ones above.

       

      Thanks so much,