6 Replies Latest reply: Jul 29, 2016 4:13 AM by Yeo Poh sai

# 6 Column Table display out stand payment , Possible to have 2 Row display % contribution ?

Hi All

I have a Table with 5 Column ,  which display the Out standing payment amount by days.

What i need is to compute the % in Pie chart to show the % contribution.

One of the approach is  i can add the column to display % contribution , it there a way i can have the % contribution on 2nd row , so that the table will not be too long.

Paul

my qvw

• ###### Re: 6 Column Table display out stand payment , Possible to have 2 Row display % contribution ?

see this expression in pie chart

num((sum(

If ( US_Cust='USD', 1.3,

If( US_Cust='MYR', 0.3333,

If ( US_Cust='RP', 0.0001,

if ( US_Cust='EU',1.5, 1)))) * curren))    /

(sum(

If( US_Cust='USD', 1.3,

If( US_Cust='RP', 0.0001,

If( US_Cust='MYR', 0.3333,

if( US_Cust='EU',1.5, 1))))* days3)

+ sum(

If ( US_Cust='USD', 1.3,

If ( US_Cust='RP', 0.0001,

If( US_Cust='MYR', 0.3333,

if ( US_Cust='EU',1.5, 1)))) * days6)

+sum(

If ( US_Cust='USD', 1.3,

If ( US_Cust='RP', 0.0001,

If( US_Cust='MYR', 0.3333,

if ( US_Cust='EU',1.5, 1)))) * days9)

+sum(

If ( US_Cust='USD', 1.3,

If ( US_Cust='RP', 0.0001,

If( US_Cust='MYR', 0.3333,

if ( US_Cust='EU',1.5, 1))))*above12)

+sum(

If ( US_Cust='USD', 1.3,

If( US_Cust='MYR', 0.3333,

If ( US_Cust='RP', 0.0001,

if ( US_Cust='EU',1.5, 1)))) * curren)),'#,##0%')

• ###### Re: 6 Column Table display out stand payment , Possible to have 2 Row display % contribution ?

for 30 days % use this

num((sum(

If ( US_Cust='USD', 1.3,

If( US_Cust='MYR', 0.3333,

If ( US_Cust='RP', 0.0001,

if ( US_Cust='EU',1.5, 1)))) * days3))    /

(sum(

If( US_Cust='USD', 1.3,

If( US_Cust='RP', 0.0001,

If( US_Cust='MYR', 0.3333,

if( US_Cust='EU',1.5, 1))))* days3)

+ sum(

If ( US_Cust='USD', 1.3,

If ( US_Cust='RP', 0.0001,

If( US_Cust='MYR', 0.3333,

if ( US_Cust='EU',1.5, 1)))) * days6)

+sum(

If ( US_Cust='USD', 1.3,

If ( US_Cust='RP', 0.0001,

If( US_Cust='MYR', 0.3333,

if ( US_Cust='EU',1.5, 1)))) * days9)

+sum(

If ( US_Cust='USD', 1.3,

If ( US_Cust='RP', 0.0001,

If( US_Cust='MYR', 0.3333,

if ( US_Cust='EU',1.5, 1))))*above12)

+sum(

If ( US_Cust='USD', 1.3,

If( US_Cust='MYR', 0.3333,

If ( US_Cust='RP', 0.0001,

if ( US_Cust='EU',1.5, 1)))) * curren)),'#,##0%')

• ###### Re: 6 Column Table display out stand payment , Possible to have 2 Row display % contribution ?

Hi Arul

I try to create 2 expression in pie chart using the expression you posted. the pie chart not able to display any thing , when i convert pie chart to bar chart , i can see 2 bar. one long and one short. mean your expression for Curren and 30days work.

Any thing i need to set on pie chart ?

Paul

• ###### Re: 6 Column Table display out stand payment , Possible to have 2 Row display % contribution ?

set dimension SOURCE

is this you are looking for?

• ###### Re: 6 Column Table display out stand payment , Possible to have 2 Row display % contribution ?

I need 8 % and 13 % in one pie chart . Now you make it in 2 pie chart.

Sent from my iPhone