Hi Everyone- I must be missing something because this is should be obvious- I want to make a crosstab in the ad hoc editor. I made a domain that gets data from a SQL table. I can drag fields that are measures into the column area, no problem. They take up one column each. And I can drag fields that are dimensions to the row area, again, no problem. I get one row for each distinct value. But when I drag fields that are dimensions to the column area I get one new column for each distinct value. This kinda makes sense since when I created the domain these were set to be "dimensions". I want them to be regular fields that occupy one column that contains the value. How do I do this? I can make the fields rows, but then they become dimensions on the rows which quickly become unwieldy. Any ideas? Thanks, Michael
