Been working on a dynamic Pivot Table where the user can select the dimensions / values that they are looking to see from a list box...
Got some great ideas from an example QlikView app that was previously posted - have included this with this discussion...
Have hit an issue which I am trying to resolve...
Screenshot 1.jpg shows the layout that I want to keep - note DateDelivery is going along the top row / 2 expressions being displayed...
Screenshot 2.jpg shows the layout after I have deselected one of the expressions i.e. am only showing 1 expression - note DateDelivery is now displaying as a normal column.
If I select another expression to display, DateDelivery moves back to the top row...
Is there anything that I can do that can force DateDelivery back to the top row regardless of how many Dimensions / Expressions have been selected?
