Listbox and Table chart

[#1]

Hi

I have 3 tables- 2 dimension(SG and Seg) and 1 fact table(fact).

'SG' and 'Seg' tables are related to each other via the column(SegmentGroupName) and 'Seg' and 'Fact' are related to each other via column (PrescriberId).

Now there's a listbox with values from the column SegmentGroupName of 'SG' table.

Now I want a table chart with the dimension corresponding to my selection in the listbox and the expression as Sum(TRx).-- TRx is a column in Fact table.

When i should select any value from the SegmentGroupName listbox (which is a column from 'SG' table )corresponding segments(column SegmentDisplayName) from the 'Seg' table should be displayed in the tablechart.

Is there a way to achieve this?

Also please do not post .qvw files as I have a personal edition.

Table Structures-

Table Name- Columns

SG- SegmentGroupName

Seg- SegmentGroupName, SegmentDisplayName, PrescriberId

Fact- PrescriberId, TRx.

[Gysbert_Wassenaar · Accepted solution]

Create a straight table with SegmentDisplayName as dimension and sum(Trx) as expression. When you select a value in the SegmentGroupName listbox the straight table will show the SegmentDisplayName values for the selected SegmentGroupName