Aggregating a column in a dataset based on value in another column in the same dataset in ssrs

• kingdonshel

  SSCommitted

  Points: 1704

  More actions

  May 21, 2014 at 5:28 am

  #396789

  I am trying to aggregate a part of a dataset to be used as an expression. I have a dataset called Weekly with some columns of with 1 is SalesSelling and another is TimeGroup, Sales as sales data values while Timegroup has String datavalues such as LW = Last Week, TW = This Week, LY= Last year etc I want to Aggregate the Sales column when the TimeGroup Column Has the LW values using an expression. I have tried:

  =Switch(Fields!SalesSelling.Value "LW", Sum(Fields!SalesSelling.Value))

  =IIF(Fields!TimeGroup.Value = "LW",Sum(Fields!SalesSelling.Value),0)

  However they don't work does anyone know how to accomplish this.

  my intension is to calculate percentage variance for last week ant this week however I need summations first.

• Jack Corbett

  SSC Guru

  Points: 184388

  More actions

  May 21, 2014 at 12:09 pm

  #1715457

  I think you want:

  =Sum(IIF(Fields!TimeGroup.Value = "LW",Fields!SalesSelling.Value,0))

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question