Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I m using list box billions,million, thousand
where the value is
=If(amt='Millions', 1000000,
If(amt='Thousands', 1000,
If(amt='Billion', 100000000,1)))
its assigned to the vAmt variable
now i m using the pie hart
dimension as
id_pass_fail field is used
expression as
=Num(((sum({<category={'AGRADE'}>}spend)))/vAmt, '$#,##0.0K')
now my issue is when ever i select the thousand in list my chart size is getting small, and for billions and millions the size of chart getting bigger
i want only the same size in chart when ever i select any thing from the dollar list of thousand or million or billions
Are you displaying the expression output on the chart itself? That might be causing it since the numbers need space to display, the chart resizes. May be try enlarging the chart so that it doesn't have to resize.
hi sunny,
yes, as per my requirement i m displaying the exp output on the chart, now any other solution is available for it, bcoz i m displaying it inside the text box where there are almost 4 charts.
Can you share image of what you have?