Standard Table Show Total by Each Product Type

[Anonymous]

Hi Experts

How would you show the total Sales by each product type..

So 

Product	Region	Sales
Apples	North	10
Apples	South	10
Apples	East	5
Apples	West	2
Apples Total		27

[lbendlin · Accepted solution]

Use a matrix visual. It has lots of controls for displaying totals.

If you insist on using a table visual then you need to duplicate your data table, rename all Regions to "Total" and then union it back with the original table.  Be prepared to explain the display to your confused users.