Payer: Combined Number and Name Logic- One Payer Name can have several Payer Numbers, so Table A always shows a list of Payer Numbers/Name Combinations. Table B should show only the SUM of the Costs of the Payer name. The Customer would like to have in Table A Number and Name combined in one column, Table B should always show the SUm of the above selection.

Table A: Variable: Payer Number/Name Combined Column A, Costs Colmun B

Table B: Payer Name Column A, SUM Costs Column B

I think the solution could be working with variables: I added two variables: Drilldown_dimensions and drilldown_text so if I select a payer both tables respond.

In Data Transformations I combined three different payer colmuns and also three different payer number colmuns to one column. So it is not possible to select only the payer_name for the selection.