SET ANALISYS

[#1]

Hi all,

I have a problem with the set analisys expression. I would like, for example, to count all my items and the total should not change when selecting other fields except one field.

To get a total count I made:

Count ((1) TABLE1.ITEM)

If I write:

Count (() <YEAR> TABLE1.ITEM)

The count will never change if I select the YEAR field. But I would like to count only change by selecting the field YEAR.

Thanks, Capetto

[villafuerte]

Hi Luca,

If you want a table to stay fixed you can use {1}, for example:

Count({1} Field)

If you want all the fields to stay fixed but you want also to change the year, yo can specify this in the Set Analysis as well:

count( {1 < Year={'2010'} >} Field)

You can use a selection or a variable instead of the 2010.

Hope it helps!

[martin59 · Accepted solution]

Hello,

You can try this :

Count ({1<Year=P(Year)>} TOTAL TABLE1.ITEM)

[villafuerte]

Hello,

I made a simple example of this syntax. Maybe it can help you!

[martin59]

Look at the attached file.

Martin

[#6]

Thank you very much. It works fine 😉