How Convert Record To Column and Calculate Difference

[#1]

hello Dears

i have One Table Look Like

I would like to give the following

[sunny_talwar]

Check 'Horizontal' on the Presentation tab:

[Miguel_Angel_Baeyens]

Hi,
GENERIC LOAD is likely what you are looking for. See here for more info:

The Generic Load

How convert table from rows to columns

Miguel

[sunny_talwar]

Just realized that you need to calculate delta also. It will be easy to add a value for change in the script. A script based solution works?

[#5]

Thanks How To Calculate Automatic Difference

2005-2006

2006-2007

2007-2008

...

[#6]

yes

but years is dynamic 2005,2006,2007,?

[sunny_talwar · Accepted solution]

This looks good (Just need a better sorting):

Script:

Table:

LOAD * Inline [

Year, Value

2005, 10

2006, 20

2007, 30

2008, 40

];

Concatenate (Table)

LOAD If(Previous(Year) > 0, Year & '-' & Previous(Year)) as Year,

  If(Previous(Value) > 0, Value - Previous(Value)) as Value

Resident Table;