2 Replies Latest reply on Feb 23, 2017 8:21 PM by y zhu

How to add a subtotal to a subcategory

y zhu Feb 17, 2017 10:17 AM

I want to add subtotals to the Product subcategories like this:

In Tableau, if I check Analysis>Totals>Show Column Grand Totals, I only got the Grand Total without subtotals to the subcategories (Product X,Y,Z):

What should I do to get the desired results?

1. Re: How to add a subtotal to a subcategory

Sankarmagesh Rajan Feb 20, 2017 1:24 AM (in response to y zhu)

Hi Y Zhu,

Refer my workaround in blogs.
Grand total for each category and measure with dimension in single column

Thanks
sankar
Like Show 0 Likes(0)

Actions
2. Re: How to add a subtotal to a subcategory

y zhu Feb 23, 2017 8:21 PM (in response to Sankarmagesh Rajan)

Sankar;

Thanks for the blog. Although this workaround summarized the data from the columns, the idea should also work for my case where I need to summarize the data from the rows. I will try it .

Y Zhu
Like Show 0 Likes(0)

Actions

Tableau Community Forums