8 Replies Latest reply: Feb 12, 2015 9:24 AM by Jasper Kotzé RSS

    Dynamic Dimension selection for a pivot table


      How can i select one or more dimensions from the list of dimensions , so that those dimensions are updated in the pivot table or a chart.


      I tried to use the $Field as a list box and then added it as a dimension of the Pivot table.

      But all the measures, dimensions are populated from the list box.

      I wanted to restrict the list.