How to create static Pivot table

[#1]

Hi

I want to create a static Pivot Table irrespective of selections.

Thanks

[MK_QSL]

You can create such type of Pivot Table (sometimes Balance Sheet) using Valuelist Function....

Consider that you have below data..

Load * Inline

[

  Customer, Sales, Qty

  A, 100, 10

  B, 200, 20

  C, 300, 30

  D, 400, 40

  E, 500, 50

];

Create a pivot table

Dimension

=ValueList('Total Sales', 'Total Qty')

Expression

IF(ValueList('Total Sales', 'Total Qty')='Total Sales', SUM({1}Sales),

IF(ValueList('Total Sales', 'Total Qty')='Total Qty', SUM({1}Qty)))

[Anonymous]

Or maybe set the Pivot Table to a dedicated Alternate State, thus it will not be affected selections on the default $ state.

[ashfaq_haseeb]

Hi,

Can you explain what are you trying to achieve.

May be you can use Alternate state for the same.

Regards

ASHFAQ

[JonnyPoole]

In each expression add the global SET IDENTIFIER

ex:

change: sum(Sales)

To:   sum( {1} Sales)

No selection will impact the chart as long as ALL expressions have the identifier {1}

[rustyfishbones]

Use Alternate States.

Create your table as normal and Add an alternate state of State1, like below

And then change the state of your pivot table to State1