2 Replies Latest reply: Aug 31, 2009 9:31 AM by LarsMadsen RSS

    Pick(Match on full data set with Set analysis

      Hi!

      Does any one know a way to make the pick(match expression work on the full set of data via Set Analysis?

      In the enclosed QV application I have two similar looking pivot tables.

      • The first one uses a normal Set Analysis expression to always represent the full set of data
      • The second pivot table aims to do the same but only in this example the set analysis is nested into a pick(match expression

      Unfortunately pick(match works on the current selection why the pivot table will only show part of the set if I e.g. make a selection on the dimension F3.

      Any feedback is appreciated!

      Lars