Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have table where in the data is as follows
Table-1
ID | Date | Value |
---|---|---|
Comp1 | 01-jan-2011 | AA |
Comp1 | 01-sep-2011 | AAA |
Comp1 | 01-jan-2012 | BB |
Comp1 | 01-sep-2013 | C |
Comp2 | 01-jan-2011 | BB |
Comp2 | 01-jan-2012 | AAA |
Comp2 | 01-sep-2012 | A |
Comp2 | 01-sep-2013 | BB |
Comp3 | 01-jan-2011 | AAA |
Comp3 | 01-sep-2011 | D |
Comp3 | 01-jan-2013 | AA |
Comp3 | 01-sep-2013 | AA |
I need to extract data as follows, how its possible
Table-2
ID | Previous Value | Present Value |
---|---|---|
Comp1 | BB | C |
Comp2 | A | BB |
Comp3 | D | AA |
The data is stored as in table 1, i need to create a chart where the value that is current or value which is lastest should show in one column and value before it changes to the current value should be displayed in another column
See attached qvw
Thanks Gysbert Wassenaar