3 Replies Latest reply: Apr 1, 2016 8:03 PM by Yeo Poh sai

# 8020 chart Display by sales ok but eXP not okay.

Hi All

I have Chart 1 work fine . When i select measure = sales. The expression as below :-

if(Num(Rank(sum({\$<year = {"<=\$(=max(year)) >=\$(=max(year)-12)"}, month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}>}sales/\$(Columndim89))

/

sum({\$<year = {"<=\$(=max(year)) >=\$(=max(year)-12)"}, month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}>} TOTAL <\$(ColumnDim_p)

> sales/\$(Columndim89))))<=15,sum({\$<year = {"<=\$(=max(year)) >=\$(=max(year)-12)"}, month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}>}

sales/\$(Columndim89))

/

sum({\$<year = {"<=\$(=max(year)) >=\$(=max(year)-12)"}, month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}>}

TOTAL <\$(ColumnDim_p)

> sales/\$(Columndim89))),

When i select meansure = eXP ( By click on step 2 ) , My expression now working.

The differeent between sales and eXP are :-

For sales = sales , But for eXP = Sum({<eXP={"eXP"}>}Amount)

My question is how to replace sales to eXP to above expression ?

Paul

• ###### Re: 8020 chart Display by sales ok but eXP not okay.

My QV Doc

• ###### Re: 8020 chart Display by sales ok but eXP not okay.

Man, your questions are such a brain teasers .

I think I am not going to help you before Monday because I need to rest my mind

• ###### Re: 8020 chart Display by sales ok but eXP not okay.

Hi sunny

yes that expression from settu , too complicated. ccan plot the chart very fast.

may be on monday you can help me use the old expression not so complicated to change to eXP as below :-

i have expresion work fine below for sales field shown in chart 1:-

sum({\$<year = {"<=\$(=max(year)) >=\$(=max(year)-12)"}, month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}>}\$(ColumnDim51)/\$(Columndim89))

/

sum({\$<year = {"<=\$(=max(year)) >=\$(=max(year)-12)"}, month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}>} TOTAL <\$(ColumnDim_p) > \$(ColumnDim51)/\$(Columndim89))

I have try as below but the chart not working :-

sum({\$<year = {"<=\$(=max(year)) >=\$(=max(year)-12)"}, month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}>}eXP={eXP}>}Amount*1/\$(Columndim89))

/

sum({\$<year = {"<=\$(=max(year)) >=\$(=max(year)-12)"}, month = {"<=\$(=max({<year={\$(=max(year))}>} month))"}>} TOTAL <\$(ColumnDim_p)> eXP={eXP}>}Amount*1/\$(Columndim89))

I am more then happy if the above work.

Paul