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
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'
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!