Can Sheet wise Data Restriction is Possible

[pra_kale]

Hi,

I am facing one problem while developing one application...

In one sheet I want to show Pivot from Year 2000 To 31 Aug 2015...This I have already build.

But, In next sheet I have to restrict data from Year 1 April 2015 and onwards in almost 10 To 15 straight Tables. One way I know is through SET analysis. But in this case I have to wright the conditions in all the tables.

So I just want to know by any way If I toggle between Two sheets I will get the desired  out-put.

Means in One sheet Start from  Inception data and in one sheet Data from April 15 onwards..

Sample application is vary useful if any one of you share.

Thanks in advance.

[Digvijay_Singh]

You can create new alternate state and assign it to 2nd Sheet objects, that way they will not be impact sheet1 objects.

[pra_kale]

Thanks for your reply...

Can you able to provide any sample application for  reference.

Thanks in advance.

[Digvijay_Singh]

Attached is the sample app -