Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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% |
Hi
Please provide more information, prefereably a sample, and much more information avout what you are trying to achieve.
Regards
Jonathan