reporting services - SSRS Nested Aggregation; Sum Max within group -


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