Pivot table filter

[#1]

Hi,

Is it possible to detach a Pivot table from one listbox filter.If so, how??

Thanks in advance.

[johnw]

One way would be to use set analysis in all of the expressions. So if your expression was this:

sum(Sales)

And you wanted to ignore the Country listbox for the pivot table, you could use this:

sum({<Country=>} Sales)

[#3]

Hi John,

Thanks for your response.But still i am unable to get it work.

Here is the screnario.Below is the structure of the pivot table

Category	Products	Qty1	Qty2	Qty3
Cat1	Pdt1
	Pdt2
	Pdt3
	Pdt4
Cat2	Pdt1
	Pdt2
	Pdt3
	Pdt4

I would like to detach the pivot table on the Products listbox selection.

Thanks

[johnw · Accepted solution]

If I understood your question, it works fine for me. See attached.

[#5]

Thanks again john.

My fact is an expression, on adding the filter the fact data column becomes like '-'.

[johnw]

What do you mean by "my fact is an expression"? Are you saying that the Category or Product is actually a calculated dimension? Do you mean you have a list box that involves an expression, so you're trying to ignore an expression, not just a field? Really no idea what you're saying.

Maybe you could modify the example to demonstrate the problem?

[#7]

Hi John,

The Q1,Q2 and Q3 values are not directly from the table column. I am doing some arithmetic operation to get those values and hence when i add the filter its not working and just display's '-'.

[johnw]

OK. What expressions are you using?

[#9]

Hi John,

Thanks for your solution it worked.

I was actually using something like $(eQty),where $(eQty) = sum(volume)* sum(buckets).I had to use sum({<Products=>}volume)*sum({<Products=>}buckets). but i was trying to use sum({<Products=>$(eQty).