Trellis Container Advance mode issue, Same Pivot Table is repeating for all the dimension
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.