Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have month as dimension, sum(amt) as expression in a bar chart.
In y -axis display I can see numbers but want $ to be prefixed to numbers.
Can any 1 tell me the way
'$'& USE THIS COMMAND BEFORE THE EXPRESSION SO U COULD GET IT
Try like this
Dual('$'&sum(amt),sum(amt))
in chart properties click expression tab you may see advance mode in that we can fix $ symbol in the desired axis
hey bro how did you exactly get the $; I did not understand, I have seen all the properties the only thing that has been making difference is the static step, may I know wat it exactly implies and how every thing varies based on steps range like what is the difference b/w static step 1,static step 2 etc...
static step 1,static step 2 : means it will increment your Y-axis my steps you mention in Static steps i.e if you mention as 5 then Y-axis values change in a increment of 5 ...like
20
15
10
5
0
Go to Number tab and select Money..
Now go to axis tab and do static step 1
Increase the height of chart
The $ is coming from the 'Number' tab in the properties.He has selected 'Money' under Number Format Settings. Static step is the increment step. On the Y axis it is incrementing by 10 (Example: 300,310,320... so on). if you want to increment the Y axis by 50 then input 50 in Static field.
Hope this helps..