Prob regarding Button

[nikhilgarg]

Hey,

I have a chart showing amount of commodities. Now i have created a button named YTD. I want that by clicking on YTD , my chart should show values of all commodities for whole current year. How can i change the values in chart by just clicking on YTD button??

tHanks

[#2]

You understood well, did you try to implement? does that solve your purpose?

[nikhilgarg]

Yeah angad,

I created a button and take 2 columns in straight table.In that on one filed i put condition with vYTD=1 and other with vYTD=0. when i click YTD button, column with vYTD=1 is shown and vYTD=0 hide.

But can you resolve my below doubt:

Let say,

I clicked Button for very first time. Then value is '1'. Now, MTD expression will get disabled because if vYTD = 1 then 0 as per if(vYTD = 1,0,1 ) .

And YTD Expression will get enabled because if vYTD = 1 then 1 as per if(vYTD = 1,1,0 ) .

Am i ryt ??

[#4]

Yes, I guess this is what the requirement is? isnt it?

[nikhilgarg]

Actually , i was going thru my dashboard , in that on click of buttons charts are changing so i wanted to know how this happens. But the questn that i asked u in previous reply was related to example given by laxmi here.

So , have i understood it ryt tha :

When I clicked Button for very first time. Then value is '1'. Now, MTD expression will get disabled because if vYTD = 1 then 0 as per if(vYTD = 1,0,1 ) .

And YTD Expression will get enabled because if vYTD = 1 then 1 as per if(vYTD = 1,1,0 ) .

[#6]

oh ok. Yes! you understood that correctly.

Please mark any response as helpful or correct if your issue has been resolved.

Thanks,

Singh