Monday, March 30, 2015

Using a Look up in a matrix

Right actually easy but took forever to find.


Just concatenate the two fields. Example:


=lookup(Fields!Mnth.Value+Fields!text.Value,Fields!Mnth.Value+Fields!text.Value,Fields!Calls.Value,"Compliments_SN")


No comments:

Post a Comment