Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I'm having difficulty creating a line chart with my data.
I have the following twelve fields that have a value and each field relates to a month ( See Below)
WOG001 = £100
WOG002 = £150
WOG003 = £300
And so on through to 012
I want to create a line chart that accumulates the fields for each period
Period 1 = WOG001 = £100
Period 2 = WOG001 + WOG002 = £200
And so on
At the moment the data set does not contain a year or period field and I'm having trouble working out how I can create a line chart that has year and period on the horizontal and value as the vertical. The fields above only contain a value and it is the field itself that defines that it relates to a particular period.
Hi I can't see an attachement
Hi
Can you explain
1. The reason for the dummy field
2. The code in T2 and what it is doing
I've created the code and I get output but now not sure what the row is for or the Kum
Hi Andrew,
like this?
Weird, I can see it attached, Ahh! you need to open the original thread.
Andy
The crosstable-statement needs at least one category-column and because your source seems to miss such column I have created this dummy. The second load is here only to show that you could easily cumulate values within the script but this could also be done within the charts.
- Marcus