I would like to create a measure

[jleefjcapital]

I would like to create a measure showing averages of three measures. I tried :   Avg(sum[New York], sum[New Jersey])) and it did not work.    

[sunny_talwar]

May be this

RangeAvg(Sum([New York]), Sum([New Jersey]))

[jleefjcapital]

Hi Sunny,

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. 

State                      Index

Mississippi              85.9  

Arkansas                 87.1

Michigan                  89

Oklahoma                89.2

I would like to create a separate field for each state.   Is there an efficient way to do this using the crosstable function? 

[sunny_talwar]

May be this

The Generic Load

[jleefjcapital]

Can I use this in Qlik Sense? 

[sunny_talwar]

Sure

[jleefjcapital]

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 : 

                                       Index

[Middle Atlantic States]      118.1

[Pacific States]                    90

[New England States]          131 

Currently, I'm getting :

Index      [Middle Atlantic States]

101.4               101.4

121.9              121.9

131                  131

[sunny_talwar]

I don't know what you want and neither do I know what you are getting right now . Unless you are able to share a sample or script or images... I won't really know what is that you are getting... and after that may be explain what is that you want....

[jleefjcapital]

I'll have to attach to a new post.   I'm not able to attach anything to these replies.