Calculation Error in Table Chart

[jmonroe918]

I am creating a table chart from a spreadsheet load using cross table.

I'm trying to create a Summary listing Sites as a Dimension and several columns by Type. The calculation I am using is as follows:

=sum({<[Type] = {'Material Variance'} >} Data)

This repeats for the other "Types" (Line Scrap, Refurbish, etc). But I am getting "//Error in calculated dimension". I need a total sum of each Type for each Site. The formula does give an amount in the Text Box, but doesn't filter by the Type specificed.

The QVD and Spreadsheet are attached.

Thanks

[Anil_Babu_Samineni · Accepted solution]

Set analysis won't work in Dimension level. It will work only on expression level

[avinashelite]

Try like this

Aggr(sum({<[Type] = {'Material Variance'} >} Data),Dimensions)

[tresesco]

Are you looking for something like :

If so, take the calculated dimensions to Expression tab.

[jmonroe918]

Anil, thanks so much for the help. It worked perfectly.

Jeff

[jmonroe918]

Thanks Tresesco.

Jeff

[tresesco]

Anil Babu Samineni wrote:

Set analysis won't work in Dimension level. It will work only on expression level

This is not true.

The same can be done in the dimension level as well, you would just need an aggr() like:

=Aggr(sum({<[Type] = {'Material Variance'} >} Data) , Site)

[Anil_Babu_Samineni]

True, I am saying about his way without Aggr function. And then the same way you suggested in the expression that is the same way I've given and followed. Thanks for thought