Hi
I have a pivot table, with two dimensions and multiple measures with Indent rows.
The requirement here is to Show that based on the Other dimension (Name DF) which has 5 Distinct data points in that column
we thought of creating One Master item of that pivot table adding dimension DF in trellis Container.
| Dimensions |
|
|
|
|
|
|
|
|
|
|
|
|
| Values |
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| Month Name |
|
|
|
|
|
|
|
|
|
|
| Jan |
Feb |
Mar |
Apr |
May |
Jun |
Jul |
Aug |
Sep |
Oct |
Nov |
Dec |
| Opt |
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
abc |
1.01 |
1.0302 |
1.050804 |
1.07182 |
1.093256 |
1.115122 |
1.137424 |
1.160173 |
1.183376 |
1.207043 |
1.231184 |
1.255808 |
| |
cdf |
1.23 |
1.2546 |
1.279692 |
1.305286 |
1.331392 |
1.358019 |
1.38518 |
1.412883 |
1.441141 |
1.469964 |
1.499363 |
1.52935 |
| |
xys |
0.23 |
0.2346 |
0.239292 |
0.244078 |
0.248959 |
0.253939 |
0.259017 |
0.264198 |
0.269482 |
0.274871 |
0.280369 |
0.285976 |
| |
efc |
0.45 |
0.459 |
0.46818 |
0.477544 |
0.487094 |
0.496836 |
0.506773 |
0.516909 |
0.527247 |
0.537792 |
0.548547 |
0.559518 |
| tpo |
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
poi |
3.2 |
3.264 |
3.32928 |
3.395866 |
3.463783 |
3.533059 |
3.60372 |
3.675794 |
3.74931 |
3.824296 |
3.900782 |
3.978798 |
| |
uyt |
1.2 |
1.224 |
1.24848 |
1.27345 |
1.298919 |
1.324897 |
1.351395 |
1.378423 |
1.405991 |
1.434111 |
1.462793 |
1.492049 |
But the problem here is same charts are repeating for all the charts in trellis, after turning on ADVANCE MODE Option
If I turn off Advance mode then '-' values is populating in the pivot table.
Please help me on this.
