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



      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