Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello Dears
i have One Table Look Like
I would like to give the following
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;
Check 'Horizontal' on the Presentation tab:
Hi,
GENERIC LOAD is likely what you are looking for. See here for more info:
How convert table from rows to columns
Miguel
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?
Thanks How To Calculate Automatic Difference
2005-2006
2006-2007
2007-2008
...
yes
but years is dynamic 2005,2006,2007,?
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;