Crosstab Calculation Question 1

[UcfMike]

I have a crosstab with a column which calculates an average. When I add summary calculations, report studio is totaling this column instead of doing a calculation to get the summary calc.

What do I need to do to get report studio to calculate the average for the summary row for this column.

 

[UcfMike]

As a follow-up question, when you pivot a list to a crosstab, what is report studio using as its default measure?

 

[UcfMike]

I found the answer to my two questions, thought I would share them.

The crosstab was giving me an average because I hadn't set my solve order for that item. When I set it to 2, the calculation worked correctly. I'm still not sure exactly why this is, but the problem is solved.

As for the other question, when you pivot a list to a crosstab, a default measure isn't created.