How to keep data inside pivot for only 1 item while several has chosen

[#1]

Hi everyone,

I've got some problem with several pivots and objects.
What i want to do is choose any variation of 2 items from listbox and get a pivot for each of them only without any other data, so for certain item i need to determine directly which pivot should contain it (6-7 tables max). Because now i get both selected items in a row inside a pivot.

I want to do it like this:

Listbox1
ob1 <-selected
ob2 <-selected
ob3
ob4

Pivot1                          Pivot2
Dim1     ob1                 Dim1     ob2

Dim2     ob1.staff          Dim2     ob2.staff

Dim3     ...                   Dim3     ...

The main question is what tipe of solution would it be: script editing or calculated dimension or expression or smth else?

[Gysbert_Wassenaar]

If you make sure to select only two values you can probably use set analysis expressions. Suppose you have sum(Sales) as chart expression. You could modify that to these:

sum({<Dim1={"$(=MinString(Dim1))"}>}Sales)

sum({<Dim1={"$(=MaxString(Dim1))"}>}Sales)

But perhaps you should consider using alternate states and use two listboxes, one for each alternate state. You can find more information about that in this blog post: Why Comparative Analysis