Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want selection on each sheet should be independent of each other. I have 4 sheets, these sheets should be such that if i give selection on one sheet it should not get affect regarding the selections on other sheets.??
Hi,
I would suggest to go for alternate states. It is a great future that fits your requirement.
Please find attached document for alternate states with set analysis by Christina Adams
BR ,
Chinna
go for comparative analysis i.e is alternate states
Hi Rohit,
If you have less number of fields in sheets then you can bypass the selections by using the
DimensionName1=, DimensionName2=, DimensionName3= in set analysis like below
Sum({<DimensionName1=, DimensionName2=, DimensionName3= >} MeasureName)
The above expression will ignore selections in DimensionName1, DimensionName2, DimensionName3 fields.
Or you can use Alternate States.
If you attach some sample file it would be even better to provide the solution.
Hope this helps you.
Regards,
Jagan.