Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This is what my table looks like currently....what set analysis can I use to make them be side by side?
yr/wk | product | region | sales | forecast |
---|---|---|---|---|
201236 | a | west | 175 | |
201237 | b | east | 500 | |
201336 | a | west | 200 | |
201337 | b | east | 400 | |
201436 | a | west | 194 | |
201437 | b | east | 345 |
I would like for them to look like this
yr/wk | product | region | sales 2 yr previously (2012 sales) | sales 1 year previously (2013 sales) | forecast |
---|---|---|---|---|---|
201436 | a | west | 175 | 200 | 194 |
201437 | b | east | 500 | 400 | 345 |
Attached is the QVW document with the table u asked for. There is a back end script change involved in it. Hope this helps.