How to add default filter on dimension in a Pivot Table ?

[ctroude]

Hi,

I'm using a Pivot Table to print the data as described below.

Dimension :

I've got a 2 filters :

• Customer
• Business Type

Mesure :

I extract one value

• Revenue

For instance :

Data before filter :

I have to delete the filter : Type and select only Customer with a default Type.

Data with filter (Business Type =I)  :

How can I add this default filter in the pivot table to print only the expected Customer ?

This filter must be a default filter means no need for the user to select the Business Type.

Only the customer for which the Business Type=I must be printed.

Thank to this the column Business Type will be not printed (deleted).

Thanks in advance for your help,

Regards,

[ctroude]

Hi,

I'm using a Pivot Table to print the data as described below.

Dimension :

I've got a 2 filters :

• Customer
• Business Type

Mesure :

I extract one value

• Revenue

For instance :

Data before filter :

I have to delete the filter : Type and select only Customer with a default Type.

Data with filter (Business Type =I)  :

How can I add this default filter in the pivot table to print only the expected Customer ?

This filter must be a default filter means no need for the user to select the Business Type.

Only the customer for which the Business Type=I must be printed.

Thank to this the column Business Type will be not printed (deleted).

Thanks in advance for your help,

Regards,

[stevejoyce]

I dont totally follow.  But you can try this.  This will filter your Revenue measure to Business Type = I if no selections are made.  If user makes selection on this field it will take into account user's Business Type selection (update business type field and revenue field/calculation as needed)

=Sum( {<$(=if(getselectedcount([Business Type])=0,'[Business Type]={'&chr(39) & 'I' & chr(39) & '}'))>} Revenue)

[ctroude]

Thanks for your quick answer.

Is-it possible to add a filter on dimension instead of mesure ?

[stevejoyce · Accepted solution]

You can make a calculated dimension in a similar way.

=Aggr(Only( {<$(=if(getselectedcount([Business Type])=0,'[Business Type]={'&chr(39) & 'I' & chr(39) & '}'))>} [Business Type]), [Business Type])

Uncheck "Include null values"

[ctroude]

Thanks for your answer.