1 Reply Latest reply: Oct 28, 2010 9:16 AM by Paul Kelly RSS

    Two expressions in a pivot table

    Fredrik Quirin

      I have to create a pivot table with two expressions. The only problem is that the first expression is only available with one specific time dimesion. As you see below, stock level is only available for the current month. I don't want to have a stock level column for those periods without values (like in the second pivot table). Is there an easy way to solve this?

      error loading image

      I have tried to create separate lines in the script for each period with dynamic variables to use as expressions in the pivot table, but there must be another way to solve this.