v8.2 problem with table

[avastani]

How can I have a chart expression ignore the values selected in a dimension and provide results. I can do this in set analysis, but looking to do it without since 8.2 doesn't have set analysis.

Is it possible?

[sathishkumar_go]

Hi Amir,

I think 8.2 is possible for set analysis.

in 8.5 we use setanalysis All

in 8.2 just try this {}

-Sathish

[avastani]

didnt work, in 8.2, can you please share what you did?

[#4]

Set analisys was first introduced in 8.5

[avastani]

that's what i thought too. hence my question if we can ignore a dimension in the expression for a table chart.

is it possible?

[#6]

Use "ALL":

sum(ALL Amount)

and combine it with IF():

sum(ALL if(Town = 'Atlanta', Amount) )

[avastani]

so if i want to make it dynamic and ignore the Town dimension but consider all other dimensions, then

SUM(ALL if(Town=, Amount))

would do it?

[#8]

nope.

That's a SET ANALISYS feature. Why don't you upgrade?

[avastani]

that's the limitation. how can i make it happen in 8.2 is the challenge. i know it is possible but i can't nail it to the syntax