presentation issue

[manoranjan_d]

I want to display the unit selection in the chart y axis , according to the selection in the dollar list box

example

dollar list box have

billions

millions

thousand

now when user select the value in the dollar list box it have to display in the y axis of the selected dollar list, so for this i have gave degree 270 and value in the chart presentation tab of the text in chart.

now my actual issue is these dollar value have to  be displayed only in the spend amount expression and not for the presentabsent expression, these two expression are simply grouped

these can be acheived or not?

chart title to be changed

[manoranjan_d]

this another issue of the chart title, now this is presntation tab issue

[Anil_Babu_Samineni]

I am not fully understand your problem. Can you please explain more.

[Anonymous]

create below one in the edit script

Load * inline [

dollar List, Scale

billions,1000000000

millions,100000000

thousand,1000

];

then go to your each and every expression just end of exp /Scale

like below exp

= sum({<Fact_type={'Direct'},$(=vYTD_Date),$(=vCurrent_Month),$(=vCurrent_Year)>}$(=$(Vunit))/Scale)

if user select thousand the y axis will change