Dear all,
Please help me on creating a pivot table with static fields.
The table looks like the one below. The dimensions A,B,C,D,E are calculated synthetically(We are using valuelist here)
Please help
| Actual Results | Trend |
| X | PY-Q1 | PY-Q2 | PY-Q3 | PY-Q4 | CY-Q1 | CY-Q2 | CY-Q3 | CY-Q4 | Q1-CY/PY | Q2-CY/PY | Q3-CY/PY | Q4-CY/PY | CY/PY |
|
|
|
| A | $1,692 |
|
|
|
|
|
|
| -7.60% | -6.40% | 1.30% | 1.60% | -3.00% |
| B | $2,477 |
|
|
|
|
|
|
| -7.60% | -5.00% | 3.00% | 1.50% | -2.30% |
| C | $908 |
|
|
|
|
|
|
| 6.90% | 1.30% | 1.70% | 7.00% | 4.10% |
| D | $1,002 |
|
|
|
|
|
|
| 8.70% | 0.60% | 0.50% | -3.10% | 1.80% |
| E | $401 |
|
|
|
|
|
|
| 1.80% | 4.20% | 6.30% | -3.30% | 2.40% |
| F | $1,476 |
|
|
|
|
|
|
| 20.80% | 20.40% | 21.10% | -5.40% | 14.60% |
