Detaching tables

[#1]

Is it possible to detach a table only from 1 specific table

for e.g. lets say i have a pivot table and multiple filters.

i want all my filters to affect the table except 1 filter

is it possible to detach my pivot only from the 1 filter ?

[rwunderlich]

You can use set analysis in your expressions to ignore selections in a specfic field. For example, if you wanted to ignore any selections in Year:

sum( {<Year=>} Sales)

-Rob

[#3]

It did not work

let me elaborate

I have a dimension PDF names in a pivot table

I have another dimension 'Product Names' in a list box

i am sourcing from excel

Since the list names are not categorised as per products, the moment someone selects a product, the pdf pivot goes blank

how can i avoid this ?

[rwunderlich]

Did you try {<product=>} in yout Pivot Table expressions?

-Rob