requirement

[Anonymous]

i have 4 buttons ,

what i want is on clicking the total,avg and percentage

so when i click on total and then percentage it shud display the percentage in the chart,and when i den swithc to total from avg the chart shud display me % of total value

with the help of variables,

how to do that

[Anonymous]

Can anyone help for the quick resolution of the said issue

[MarcoWedel]

please post a sample application to demonstrate

thanks

regards

Marco

[Anonymous]

It's on client machine ,so can't share,but basically I have created two variables and using it in layout tab show conditional but it's not giving the desired output ,button 1,2,3  1 is Shwng sum 2 AVG and 3 %of sum nd AVG now if I click on 1 and den 2 it shud display sum % in the chart and same as wth AVG how I shud set the variables acrsingly

[Anonymous]

can anyone please help on the above query ,please ,button toggle ,how to achieve the same.

[balar025]

Hi,

As i understand your requirement , you have 3 buttons,

1) SUM

2) Avg

3) Toggle for actual value or %age.

So, you can 2 variable

vCalculation = 1 for Sum, 2 for Avg

vFormat = 1 for Actual , 2 for %Age

Expression

=Num(Pick(vCalculation,sum(ValueList(10,20,30)),Avg(ValueList(10,20,30))),Pick(vFormat,'#,00;(#,00)','#,00%;(#,00%)'))

Find attachment.

**You can replace value list by your field.

Regards,

Ravi Balar

[Anonymous]

thanks,but i cant see any attachment

[Chanty4u]

Open this thread in new tab then only you can able to see the attachments.

[Muthu]

Once suggestion is in the chart create 3 different expressions for sum avg and percentage.

Create one variable.

In the buttons set variable as 1,2 and 3 for 3 buttons and in the expressions tab enable conditional and set variable as 1,2 and 3 for sum, avg and percentage expressions.

[arvind_patil]

Hi Dynamic,

With The help of pick function, you can achieve this:

Pick(Wildmatch(vValue,'SUM','Avg','Toggle for actual value or %age'),

Expression1,

Expression2,

expression3

)

Thanks,

Arvind Patil