Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a pivot table where use can select dimentions from the dimentions table using Inline statement.
I have four dimentions in Dimentions table Location, Code, Manager, State.
I created a pivot table only adding Code and State.
Now I want to add Location and Manger only when user selects them from the dimentions table.
Can I add Location aand Manager write some code in Dimensions Tab.(Enable Conditional)
Thanks
Pavan
See this blog post: Customizable Straight Table
And yes, this will work for pivot tables too.