Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.