I am relatively new to SSRS and am working on a new report. This particular report has a table with 3 columns, 2 of which have values that I want to work with (problem and value are the names). I am needing to have this second table have the sum of the two columns and then from there the average and a couple other functions.
I can't seem to figure out how to reference the columns in my other table. Do I need to go the route of creating another dataset and have SQL do the "dirty work" for me?
TIA.