Need Help on Bar Charts

[Anonymous]

Hi Experts,

I do have data table for aging like Customer code, customer name, outstanding, voucher date, AG01, AG02, AG03, AG04, AG05+. These

AG series are Monthly aging buckets.

Now i need to present numbers in bar chart with out using cross table functionality.  Since this all in columns i am facing difficulties to bring them in bar chart.

I would really thankful if some one could help on this.

Thanks,

Raju K

Data Table:

Customer Code	Customer	Outstanding	VDate	AG01	AG02	AG03	AG04+
0001	Al Raya Center	1000		1000
444	Fine Hyper market						9000
875	Maya Super market					1200

[marcus_sommer]

You need to transform your data into a "normal" data-structure with The Crosstable Load

- Marcus

[Anonymous]

Agreed with Marcus Sommer‌.

Did you try with the same data in creating a Bar chart, what issue you faced?

If it is just to plot a Bar,

Take Customer as a Dim

& Write these expression like:

Outstanding= sum(Outstanding)

AG01 = sum(AG01)

and so on till AG04+

[Anonymous]

No Balraj, I need these column names should come as demension.

[Anonymous]

thanks marcus, would you suggest any other way other than using cross table functionality.

Thanks & Regards,

Raju .K

[HirisH_V7]

Hi,

Please elaborate and tell your requirement on Bar chart what to be displayed.?!

-Hirish

[marcus_sommer]

No, I wouldn't. The advantages of a "normal" structured table are huge against a crosstable and if you used a pivot-table you could easily create such a crosstable-view within the gui again. And if you really have a situation by which you need them somehow separatly you could use set analysis like:

sum({< [Monthly aging buckets] = {'AG01', 'AG02' /* .... */ }>} AnyValues)

whereby I would transform the AGxx into Month and associate them with a master-calendar: How to use - Master-Calendar and Date-Values

- Marcus