Re: How to switch different expression in a pivot table?
Create a drill down group with Month and Day. That will create the dimension behavior you are looking for.
Create two expressions with expression conditions using a variable. Set the variable to 1 when clicking the Amount button or 0 when clicking the Quantity button. Use the conditionals for the two expressions:
=if(vForm = 1, 1, 0)
=if(vForm = 0, 1, 0)
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein