How to fix the table static?

[bhaveshp90]

Hello, 

I have a simple straight table as shown below; 

I want to make this table static irrespective of the Data field that is selected in my sheet. 

Do I need to create a new alternate state so that it doesn't change with the selected fields in the sheet?

thanks

Bhavesh

[jensmunnichs · Accepted solution]

What is your expression in the PAC delay column?
You can add a 1 to the set analysis to have it ignore selections.

For example: Rank(Sum({1} Sales))

Or if you need it to have some selections: Rank(Sum({1<Product = {'Shoe'}>} Sales))

[bhaveshp90]

I have the below expression;

 if(Sum(Go_Live)>3500, null(),
Sum({<Snapshot_Date = {">=$(=Date(Addmonths(Max({1} Snapshot_Date),0), 'YYYY-MM-DD'))"}>}Go_Live)
/
count({<Snapshot_Date = {">=$(=Date(Addmonths(Max({1} Snapshot_Date),-1), 'YYYY-MM-DD'))"}>}distinct Milestone_Project_Number))

I tried to include {1} before Sum and count expression, but it is not working out. Can you tell me where should I use {1} in my expression.

[hopkinsc · Accepted solution]

Hi. 

the 1 should go here..

if(Sum(Go_Live)>3500, null(),
Sum({1<Snapshot_Date = {">=$(=Date(Addmonths(Max({1} Snapshot_Date),0), 'YYYY-MM-DD'))"}>}Go_Live)
/
count({1<Snapshot_Date = {">=$(=Date(Addmonths(Max({1} Snapshot_Date),-1), 'YYYY-MM-DD'))"}>}distinct Milestone_Project_Number))

try that.