7 Replies Latest reply: May 15, 2012 2:40 AM by lixiaowei RSS

Pivot Table: Conditionally hide/display expressions

Julie Stephens

I have a series of pivot tables created. I would like the user to be able to choose which of the following possibilities to display:

  1. Units (POSUnits)
  2. Amount (POSAmount)
  3. Both Units & Amounts

I was thinking of creating an input box that would allow the user to select an option from a drop-down list, then use variables to show or hide expressions. In other words, I would like to conditionally display or hide pivot table expressions. Can this be done? If so, how?

Thanks in advance for your help!