Facing issue with conditional show hide in pivot using value list.
Have attached the file with explanation.
In value list i have "One" and "Two" columns. For "One" column I intend to show only months (Apr, May and June) and for "Two" I intend to show the net differences (Diff Jun, Diff May etc ) only.. But currently it is showing all in both "One" and "Two" column means under column "One" I have Apr, May, June, Diff May, Diff Jun and In column "Two" also appears Apr, May,Jun,Diff May, Diff Jun.
What I want to achieve is under column "One" There should only be months i.e Apr, May and June and under column "Two" should be only difference i.e Diff May, Diff June..
I tried condition show column but its not working .. It hides that month from both column One/ Two..
