Units not displaying properly in table box

[#1]

Hello,

I want to create a table box to accompany each chart I'm creating.  Below is a screenshot of the issue I’m facing when trying to display units for each product segment by quarter.  Instead of showing 12 quarters worth of unit results in the table box, I’m getting multiple results for each quarter and segment (see first table box).  I’ve created a second table box to show you what I’m trying to achieve.  Basically, I want the second table box to display the unit column with the results in the chart.

If anyone can assist in getting the units to display properly in the table box, I'd greatly appreciate it.

Regards,

Robert

[jpapador]

You have to make a straight table instead of a regular table box use Quarter and Segment as your dimensions and them Sum(Units) as your expression.  You could actually just copy your bar chart, then on the general tab (on the properties of the chart) change it from a bar chart to a straight table

[#3]

Hi,

Thanks for your quick reply.  As you suggested, I copied my bar chart, then in the copied chart, I selected Properties and changed it from a bar chart to a straight table and it worked fine.

Regards,

Robert

[whiteline · Accepted solution]

Hi, Robert.

If the issue was solved, mark the jpapador's answer as correct to close the question, please.

Thanks.