First off, thanks for posting in these forums. They have been immensely helpful.

I need to create a table that contains numeric and string variables. The table is structured such that each identifier lines the first row and each descriptor (both numeric and string) lines the first column.

So far, I have been able to do so only with numeric (measure) variables by dragging these variables into the measure values section, then dragging measure values into rows. These numeric values automatically turn to "Sum of [Var]" and giving me the correct display I want. However, categorical/string values are not allowed in the measure values shelf.

The table will also need to filter by an identifier. Please find attached an example workbook demonstrating this problem. In this workbook, I would like to put [State] and [Country] in the same column as [Population] and [Change].

Unfortunately, this is not what I'm looking for. The solution you suggested, while it displays the State and Country, repeats in each row. I would like to have State and Country in their own rows (similar to how Population and Change are in their own rows). Therefore, no information is repeated.

To provide some context, I would like this to be a drop down where the end user can look at all of the information associated with a unique City that is selected (not just the numeric info).

Please see the attached screen shot as an example of what I would like eventually.