Ignore Selection made in a list box

[#1]

Hi!

I've a Pivot table which i want to ignore a selection made by a list box.

Should this be done by set analysis?

The list box list all SITEID's and I want the user to do a selection but it shouldn't affect the pivot table (i want it to show all siteids)

//BR
Patrik

[Miguel_Angel_Baeyens]

Hi Patrik,

Generally speaking, the following syntax will ignore selections in field SITEID. The right part is empty on purpose, it's not a typo.

Sum({< SITEID = >} Value)

Hope that helps.

Miguel

[#3]

Sorry for my stupidity, but where should i use this?

[Miguel_Angel_Baeyens]

Hi Patrik,

No stupidities here, we are all learning. In the pivot table, as in almost any other chart, there are two "mandatory" things: dimensions and expressions. In this case, the code above would be the expression.

Hope that makes sense.

Miguel

[#5]

Hello!

I can't get it to work, In this case the dimension is SITEID and SITEID is text so can you still use sum?

//BR
Patrik

EDIT: My head seems to come to it senses right now

But one question. can this be applied on a table that is text? (regarding the SUM action)

[Miguel_Angel_Baeyens]

Hi,

Nope, the Sum() function will return null "-" when the value is not numeric. But then, why do you want to use a pivot table? You could upload some sample data so we can figure it out.

Miguel

[#7]

Hmm I'm stuck.

Simply I want the whole pivot table to ignore the selection of SITEID (all other selections, date etc i want to work)

[Miguel_Angel_Baeyens]

Hi Patrik,

You better upload some sample data so we can figure out what do you expect. Expressions as shown above should work, but if they are not, I'm afraid I cannot go any further.

Miguel