Get information from related table

[Renan Melo]

Hi All,

I am facing a problem, I would like to get help on that.

I have table A and table B linked by ID.

I have created a visualization to show how many Type from Table B in relation to Table A, I choose Table B as main table then select "Type" as Categories Axis and "count([Table A].[iD])" as Value Axis I got the same number for all categories (see example in attached).

How should I do in this case avoiding insert column 'Type' from Table B in Table A

[David Boot-Olazabal]

Hi Renanh_36,

 

Please see atached dxp for the solution. I have added the columns from your table A to table B. Then, you will be able to calculate the proper number of rows per type, shown in the bar chart.

Kind regards,

David