Ignore selections in a pivot table

[Anonymous]

Hello,

I've got a pivot table with dimension Customer and expressions Amount + Period.
There are two selection tables: Customer and Period.

When I change the Customer or the Period the Amount is changing.

I want to create a second Pivot table with dimension Customer and expression Amount.
When I change the Period in my selection table, I want the first Pivot table to change the Amount and the second pivot table not.

Is it possible to ignore one of the selection tables in a Pivot table?

[advait_thakur]

Hello,

  Yes it is possible you may restrict the selection by adding Set Analysis in your expression.

By this way, if you have two pivot tables A and B then A will change and B will remain same.

Thanks

Advait

[kaushiknsolanki · Accepted solution]

Hi,

     You need to include set analysis to ignore the selection.

     Try below expression in your second pivot.

     Sum({<Period = >}Amount)

Regards,

Kaushik Solanki