I realized that before I can average across states, I need to order the data set. Currently, the data are organized with a State column associated with an Index column.
I would like to create a separate field for each state. Is there an efficient way to do this using the crosstable function?
It worked, but I'm having trouble assigning the correct dimension for this newly created aggregate.
I thought "Index" would be the natural dimension, but when I use this as a dimension, the created measure is broken out into the subcomponents.
I'm not sure what I'm doing wrong.
This is how I'd like to view the data :
[Middle Atlantic States] 118.1
[Pacific States] 90
[New England States] 131
Currently, I'm getting :
Index [Middle Atlantic States]