Dynamic Columns - values from table via input box?
Hi,
I got a case wherewe need to lets users build their own customize rapport where they can compare the values.
Lets say I build a table where I'll put day (column 1) .
Then I need to create dynamic cuztomized columns lets say where users should be able to decide them selves what to choose: i.e.
1 column for Articles (Books, Music, Movies)
4 of the same type of columns with dropdown box/menu for Countries (Denmark, Norway, Sweden, Island, Germany, France, Italy, Spain)
the point is that the users can choose lets say:
Books and then to se the prices for comperision in the 4 different countries of their choosing in the next 4 collumns next to each other. lets say Denmark against Island against Italy against Sweden.
If you have QV11 you can use conditional expressions for Dimensions. See attached example. The items to show are selected in listboxes. Multiboxes works as well. But dropdown boxes in the pivot table itself won't work.
If you have QV11 you can use conditional expressions for Dimensions. See attached example. The items to show are selected in listboxes. Multiboxes works as well. But dropdown boxes in the pivot table itself won't work.
