How to combine 2 chart into 1 chart ?

[paulyeo11]

Hi All

I have 2 chart A & B. I like to combine into one chart C.

My Chart A expression as below :-

Sum({<SEGMENT -= {'Related Coy'} >}total_ar * Pick(Match(US_Cust_AR, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD', 'MYR', 'RP'), 1.64, (1/24), 1.25, 0.012, 1/24, 1,1/3,1/9600))

My Chart B expression as below :-

Sum(total_ar * Pick(Match(US_Cust_AR, 'EUR', 'NT', 'USD', 'YEN', 'BAH', 'SGD', 'MYR', 'RP'), 1.64, (1/24), 1.25, 0.012, 1/24, 1,1/3,1/9600))

Both Chart A & B have same dimension :-

=If(aging_ar >= 1 and aging_ar <= 30, Dual('1-30', 1),

If(aging_ar >= 31 and aging_ar <= 60, Dual('31-60', 2),

If(aging_ar >= 61 and aging_ar <= 90, Dual('61-90', 3),

If(aging_ar >= 91 and aging_ar <= 120, Dual('91-120', 4),

If(aging_ar >= 121 and aging_ar <= 150, Dual('121-150', 5),

If(aging_ar >= 151 and aging_ar <= 180, Dual('151-180', 6), Dual('>181', 7)))))))

Hope some one can advise me.

Paul Yeo

[paulyeo11 · Accepted solution]

Hi All

I have solve the issue , case closed.

Paul Yeo

[#3]

Great PAUL..

How did you fix ?

[paulyeo11]

Hi Maheswara

I create one expression include related company , that is with out the -ve sign , another expression is using the expression -ve sign .

And I change the chart to combo chart , and make the chart stack up.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

[#5]

Thanks for sharing your approach:)