Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to add dimentions to piovt table dyanmically

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

2 Replies
Gysbert_Wassenaar

See this blog post: Customizable Straight Table

And yes, this will work for pivot tables too.


talk is cheap, supply exceeds demand