I have simplified my requirement.
Let's say we have the data below
| Month | Sales |
| 1 | 1000 |
| 2 | 2000 |
| 3 | 3000 |
| 4 | 4000 |
| 5 | 5000 |
Now I want to create a straight table in Qlik as below.
| Month | This Month Sales | Next Month Sales |
| 1 | 1000 | 2000 |
| 2 | 2000 | 3000 |
| 3 | 3000 | 4000 |
| 4 | 4000 | 5000 |
The month field should be in the straight table as the first dimension. How can I achieve this? I am unable to get the next month sales in this table because we have the Month dimension part of this table??
