Unable to Run Crosstab Correctly

[TheKillFloor]

Hello everyone. I've finally decided on moving to Report Studio from Query Studio, and it's been amazing. I'm almost complete with automating a multipage report! However, I'm running into a few issues:

The problem that I'm concerned about most is creating a crosstab with calculated fields.  I have four fields in use: Row-Location (cased to condense to city/state into state);  Column1-Expense Type (cased to form one colum) and Measures- Approved amount. Then I add Column 2-Headcount (cased from location with set values).

I run the report, but instead of seeing indivual headcount numbers per location I am seeing column headings of headcount numbers. And each locations total spend underneath. I know that I must be making a noob mistake. Any suggestions please?  :) -William

[blom0344]

The key to success is in the order in which the crosstab is assembled.
Drag  2 measures  not in the body but in rows or columns and THEN superimpose the required dimension above them. It takes a little fiddling to get the proper 'feel'

[TheKillFloor]

Thanks for the reply/help. I managed to get everything in there besides an average calculation, it's not liking that so much. I'm OK to update that manually until I figure it out. Thank you!