sql server - SSRS: How to SUM row data based on condition -


i have table of structure:-

row1:- not inside details group.

row 2:- dynamically populating row. sequence as:-

a x

a1 1

a2 2

b y

b1 30

b2 40

i need calculate value of y(which value of b1+b2) , x(which value of a1+a2)

also in row 1 need display x+y.

please note:- not sure number of rows can there in either or b. y can b1+b2+b3.... on.

also , b being populated same dataset.

it's bit unclear how data set can't give answer summing based on condition you'd want like:

=sum(iif(fields!a.value = "x", fields!unknown?.value, 0)) 

this sum of unknown field when field a = x.

if isn't looking for, try adding field names , relate them values.


Comments

Popular posts from this blog

How has firefox/gecko HTML+CSS rendering changed in version 38? -

javascript - Complex json ng-repeat -

jquery - Cloning of rows and columns from the old table into the new with colSpan and rowSpan -