3 Replies Latest reply: May 17, 2012 2:48 AM by Jason Michaelides RSS

    Set Analysis - Sum by Dimension B when Dimension A selected

    Joe Kirwan

      Hi

       

      I have 3 fields Date, Week and Val

       

      In my table I have an expression sum(Val). When I select Date, it will sum the Val for that Date.

       

      I want to add another expression to sum the Val for all Dates in the Week corresponding to the selected Date.

       

      Any ideas

       

      Ta

       

      Joe