Forum Discussion
Standard Table Show Total by Each Product Type
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 Tota...
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.
lbendlin
Super User
Super UserUse 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.