text change whilt click on it.

[Anonymous]

hello everyone,

i have text object & i want to show PRODUCTION as well as SALES as text. when i click on Production it will change to Sales.

How to write expression i am not getting. please help me to find out.

Thank You...

[t_chetirbok]

hi,

Do you mean that you want to have a text object as a "button"?

[Anonymous]

yes

[t_chetirbok]

Create vShow variable

[Anonymous]

already tried but not working

[t_chetirbok]

really?

maybe I don't understand then, what you are trying to do)

some more details?

[Anil_Babu_Samineni]

prachi dhok wrote:

hello everyone,

i have text object & i want to show PRODUCTION as well as SALES as text. when i click on Production it will change to Sales.

How to write expression i am not getting. please help me to find out.

Thank You...

May be this?

=PRODUCTION & ' : ' & Sum(SALES)

[stabben23]

Well, it does! otherwise describe whats Your problem is more clearly.

[Anonymous]

production and sales are kpi value. i have to used only one text/ button . while i click on production it will shows production's values/ info and simultaneously text will be change as sales

[stabben23]

If you want to see Sales and producton values, change text like this:

=if(vshow=1,Sum(Sales),Sum(Production))