How can I manage selection (default selection) in straight table?
Hi all,
I created a straight table, the dimension is calculated, which is something like: =Pick(Match(Program, 'P1', 'P2', 'P3'), [P1 Name], [P2 ID], [P3 Org]) . Everything looks fine. For example, when I make selection Program='P1', the table will show all P1 names together with all related aggregation values. My fact table for this calculated dimension part showed below.
Program
P1 name
P2 ID
P3 Org
P1
name1
ID1
O1
P1
name2
ID2
P1
name1
ID3
O1
P2
name3
ID3
P2
name3
ID2
P3
name3
ID1
O2
So, in my straight table, when Program='P1', the calculated dimension should show name1 and name 2. Program=P2, show ID2 and ID 3, etc.
It is fine when just look at the straight table, but when I click to select name1, I just want to see name1 aggregated information, which should only show me one row. however, I got wrong result, and the current selection section showed, I selected P1 name name1, P2 ID ID1 and P3 Org O1 at the same time. I think it makes sense since I have 3 columns used for this calculated dimension. If I create a list box just show P1 name field and make selection, the straight table will display correctly.
