Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
just a quick and I'm sure relatively simple question. I have a set of data that I am using, one of the columns is our financial period 1 -13, this is stored in a single column, what I would like to be able to do is create a table with the data set with columns 1-13 spread accross the top of the table as seperate columns and the data filled in beneath, how do I do this?
Many Thanks
Ben
You can also create a pivot table in which you drag the period column to the top of the chart.
Use the CROSSTABLE Statement bevore the load.
Crosstable (period ,data,2) Load * from ex2.csv
It meens
2 Fiels will not turn
period is the name of the Column Heading (1..13)
data is the name of the content
Simple use the "table files"-assitant in the scripteditor
Have Fun! Regards
Dirk
You can also create a pivot table in which you drag the period column to the top of the chart.
You can also create a straight table in which you select Horizontal on the Presentation tab of the properties.
Hi, I'm sorry I can't fathom how to get these cross tables to work, If my spreadsheet looks like this:
Description | Period | Amount |
Desc 1 | 1 | 100 |
Desc 2 | 3 | 10 |
Desc 3 | 4 | 20 |
Desc 4 | 5 | 25 |
Desc 5 | 7 | 32 |
Desc 6 | 8 | 54 |
Desc 7 | 10 | 98 |
Desc 8 | 11 | 78 |
Desc 9 | 13 | 45 |
Desc 10 | 9 | 98 |
Desc 11 | 2 | 45 |
Desc 12 | 6 | 12 |
Desc 13 | 11 | 32 |
Desc 14 | 13 | 45 |
Desc 15 | 12 | 78 |
Desc 16 | 3 | 12 |
Desc 17 | 5 | 32 |
Desc 18 | 6 | 45 |
Desc 19 | 8 | 844 |
Desc 20 | 7 | 98 |
Desc 21 | 9 | 54 |
Desc 22 | 10 | 21 |
Desc 23 | 11 | 2 |
Desc 24 | 5 | 5 |
Desc 25 | 6 | 84 |
Desc 26 | 8 | 98 |
Desc 27 | 9 | 88 |
Desc 28 | 3 | 54 |
Desc 29 | 4 | 21 |
Desc 30 | 2 | 954 |
And I want the periods to be transformed into a layout like this:
Description , Amount, Period 1,2,3,4,5,6,7,8,9,10,11,12,13 - how do I get there?
Thanks
Ben
How do you find horizontal on the properties? When I create a standard table I cannot find any part that says horizontal - am I missing something?
Ok, I misunderstand you.
Read the table it is it.
User a pivot table (chart) with dimension Period and and move the dimension clomn to the column headings with your. The blue arrow show where they are.
-Dirk
ben.shreeve wrote:How do you find horizontal on the properties? When I create a standard table I cannot find any part that says horizontal - am I missing something?
What do you mean by a "standard table"? What I meant was a "straight table", which is a form of chart. The "horizontal" checkbox is highlighted in black below:
Hey thanks all, managed to get things sorted with the pivot table!