related questions:
summing group items in ssrs 2008 r2
ssrs sum max group
ssrs 2012. need nested aggregate, sum(max()) on matrix row group "location" , column groups "month" , "day" respectively.
i have formula:
=sum(max(fields!cards_ship.value, "day"),"month")
it correctly sums max(cards_ship) day within month. however, doesn't stay within scope of row group "location". location has sum(max(card_ship)), value gets repeated each location , total.
i have tried:
=sum(max(fields!cards_ship.value, "day"),"location")
but won't let me define scope across 2 axes (row , colmn).
input appreciated!
edit: sorry don't understand table/data formatting.
currect:
loc mtd 1st 2nd
20 10 10
b 20 2 2
tot 20 12 12
expected:
loc mtd 1st 2nd
20 10 10
b 4 2 2
tot 24 12 12
Comments
Post a Comment