reporting services - Pivot table with dynamic columns with average? In SSRS? -
i have sql table/query gives me these columns: date testname testvalue i want report gives me this: date test1 test2 test3 3/1/2011 25 22 19 4/1/2011 22 32 12 average 23.5 27 15.5 i can matrix spread test types out... can subtotal. how can average? click on data cell in matrix , right-click , change field expression =avg(fields!testvalue.value) i believe looking for.