How to create a button in such a way that it links a number of sheets

[ferha_jafri]

Hello all,

I want to create a button such that when i clik it for the 1st time it navigate me to first sheet ,when i hit it second time it navigate me to the second sheet and so..

Plz help on this.

With regards

Ferha Jafri

[#2]

Hi..

For two sheets,u need to create two button object..

Becoz one can activate only one sheet.

[ferha_jafri]

Thank you for your reply .

[#4]

Just check the attached QVW.

[ferha_jafri]

I have another questions if anyone could ans ,i am trying to find sum of money measure but i have some field values which i have to be present in the straight table as dimension but there values are missing in the calculated sheet so when i am trying to diplay them i am not getting these field values in the dimension column.Is there any way to show them althogh there is no calculated expression for them.

Thanks in advance

Ferha Jafri

[tresesco · Accepted solution]

May be you are asking for this?

Under the 'Dimension' tab select the dimension and check 'Show All Values'.

Thanks.

[#7]

In Presentation Tab just Uncheck "Suppress Zero-Values"

& Dimension Tab Check "Show All Value" & "Suppress when value is null"

Regards-Bika

[ferha_jafri]

Thank you all this works.