Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
this another issue of the chart title, now this is presntation tab issue
I am not fully understand your problem. Can you please explain more.
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