1 Reply Latest reply: Feb 20, 2013 7:38 AM by Jonathan Brough RSS

    Ignoring dimension with set clause

    Mika Lindman

      Hello,

       

      I'm trying to create a table that looks something like this

      table-example.jpg

       

      I'm having trouble on creating the "Year total" expression. This should be the sum of "Sales" with only "Product" as filtering variable. When I try to do this with set clause it also uses "Quarter", giving the sum for the "Quarter", not the whole dataset. Here's my set clause

       

      = Sum({$<Year={Year(Quarter)},Quarter=>})

       

      Any help on how to achieve something like this?