Filter Pivot Table without user making a Selection

[#1]

I am looking to create either a table or pivot table for checking stock conditions of manufactured "M" or bought out parts "B"

Is there a way to filter the table permanently so that it always only displays "B" items or "M" items regardless of any other selections made in the sheet.

thanks

[matt_crowther]

Add a 'Calculated Dimension' under the dimensions tab of the Straight Table along the lines of the following:

=if(Item_Name='B' or Item_Name='M',Item_Name)

Then check the 'Supress Where Value is Null' check box.

That method works for me.

Hope that helps,

Matt - Visual Analytics Ltd

[#3]

Hi not quite what I need I don't believe, can I get it to show only the 'B' items for example without any selections being made.

[matt_crowther]

Here's what the posted formula should be doing - with NO selections:

The first is a simple Straight Table with 'Name' as the dimension - all 'Name' values are returned as lon gas they have a sale against them.

In the second I've added a Caluculated Dimension =if(left(name,1)='P',Name) - no selections are made at any point.

The Calululated Dimension expression can also work across more than one dimension so you could use:

=if(count(Stock_Level)>10,Item) or perhaps more in your case: if(Name='B' or Name='M',Item)

If that's not the solution then I'm missing what you're after I'm affraid.

All the best,

Matt - Visual Analytics Ltd

[#5]

Hi Matt

That's brilliant thanks

Steve