SSRS 2008 Matrix Percentage of Parent Row Group Each Column Group

• wesflake

  SSC Rookie

  Points: 42

  More actions

  June 4, 2010 at 7:18 am

  #233330

  I have a report, column group Period, row groups of Division and Warehouse.

  I am trying to have a cell display the percentage of sales of each warehouse/it's division.

  Using sum(fields!sales)/sum(fields!sales,"Division") does not work because sum(fields!sales,"Division") is the sum of the entire row for the division not just the period. This is what I want.

  Period 1 Period 2 | Total

  __________Sales__Pct___Sales__Pct__ | _____

  Division 1 $4 $6 | $10

  Whse 1 $3 75% $4 67% | $7

  Whse 2 $1 25% $2 33% | $3

  Thanks, any help is appreciated.

  Wes

• sqlqueries23

  Valued Member

  Points: 52

  More actions

  October 21, 2011 at 12:35 pm

  #1398177

  Hi,

  Did you somehow get this to work? I am attempting to do the the same thing without any success. Any luck?

  Thanks!