CHARTS

[#1]

Hi experts,

This is my source file .

Country	Product	Number of Invoices Pending for selected period	Invoices Amount Pending	Number of days invoice is pending	Total Number of customers for which invoices are pending	Invoice Pending Reason
USA	Valve Steel	10	1000	110	2	Customer did not pay on time
USA	Alloy Tool Steel	20	2000	120	4	Money did not received to the account
USA	Stainless Steel	30	3000	130	7	Customer did not pay on time
China	Valve Steel	11	1000	110	8	Customer did not pay on time
China	Alloy Tool Steel	21	2000	120	7	Money did not received to the account
China	Stainless Steel	31	3000	178	2	Customer did not pay on time

please find the attached document This is original "OUTPUT". but   i am not getting correct output. anybody help me.

[#2]

Add Country, Product in dimensions and in the expressions add 4 different expressions with sum(fieldname) for each and check values on data points to display

Thanks,

SV

[#3]

make country and product dimensions and then the other fields (with the excption of reason) as your expressions, and use sum() function

[#4]

i have tried but i am not getting correct output can send example with my data and how i can i draw the lines on chart

[#5]

please attach qvw

thanks

[simospa]

Hi,

to draw lines in chart you have to to to Chart Properties --> Axes --> check the Show Grid Flag.

Then, I'm sorry but you cannot have 2 dimensions and 4 measures, take a look here:Is it possible to have a grouped bar chart with 2 dimensions without it forcing stacked bars?

Let us know.

S.