Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
You need to transform your data into a "normal" data-structure with The Crosstable Load
- Marcus
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+
No Balraj, I need these column names should come as demension.
thanks marcus, would you suggest any other way other than using cross table functionality.
Thanks & Regards,
Raju .K
Hi,
Please elaborate and tell your requirement on Bar chart what to be displayed.?!
-Hirish
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