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