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




      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,