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?
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.
Attached is an example which I downloaded from another posting - think from John Witherspoon.
Apologies if I am wrong but I think this may be what you are looking for...