8 Replies Latest reply on Oct 24, 2016 3:52 AM by Rahul Verma

# How to calculate Subtotals and Grand total by average since values are % values (not by using Analysis=>Totals)

Hi I have a scenario as below.

I have a Dimension named "Region" where i have 10 regions which starts with letter "R" and 4 GSC's which are starting with "GSC". Please see the pic below for better understanding. No my requirement is i need to display Totals.

For Regions it should be "Total Regions" this should be displayed right after Regions

For GSC's it should be "Total GSC's" this should be displayed right after GSC's (last but one row)

Grand total should be displayed as : "Total Region + GSC" this is displayed as a last row

Please find below pic for the target view:

I don't want to use built in method of tableau to calculate grand total, because with that i can not calculate total of Regions and total of GSCs and also i can not rename label names as per my requirement.

• ###### 1. Re: How to calculate Subtotals and Grand total by average since values are % values (not by using Analysis=>Totals)

Hi Kalyan,

Please use groups to get the output. Refer the below screenshot. Please find the attached workbook. Its been created in tableau 10. Groups has nothing to do with tableau version. You can simply create groups.

Thanks and Regards,

Ashish Chaudhari

2 of 2 people found this helpful
• ###### 2. Re: How to calculate Subtotals and Grand total by average since values are % values (not by using Analysis=>Totals)

Hi Ashish,

How you calculated the total, can the total labels will be renamed??

Can you please attach the actual workbook?

• ###### 3. Re: How to calculate Subtotals and Grand total by average since values are % values (not by using Analysis=>Totals)

Hi Kalyan,

I have already attached the workbook in the first reply. Please check. You can calculate the totals and subtotals with a single click by going to Analysis option in the Menu Bar.

Please refer to the below screenshot.

Thanks and Regards,

Ashish Chaudhari.

2 of 2 people found this helpful
• ###### 4. Re: How to calculate Subtotals and Grand total by average since values are % values (not by using Analysis=>Totals)

Hi Kalyan

I hope you're looking for something like this.

Subtotals are done, their "Names" are re-labelled! Finally, to calculate the grand total of all Ps and Rs, name is given as "P+R Totals" and value is correct!
You can achieve this at dashboard level only. Please follow the Dashboard i created in attached Workbook./

Kindly do let me know it helps

Thanks

Rahul

1 of 1 people found this helpful
• ###### 5. Re: How to calculate Subtotals and Grand total by average since values are % values (not by using Analysis=>Totals)

In Addition to the first reply, I have mocked up the data myself! Never mind!
Some names are there with "R" and "P" and some respective Values!
Hope you got it

Regards

Rahul

1 of 1 people found this helpful
• ###### 6. Re: How to calculate Subtotals and Grand total by average since values are % values (not by using Analysis=>Totals)

Hi Kalyan,

You Can change rename the totals.

-Ashish Chaudhari

2 of 2 people found this helpful
• ###### 7. Re: How to calculate Subtotals and Grand total by average since values are % values (not by using Analysis=>Totals)

Hi Rahul,

This is what something i am looking for, can you please attach the workbook as i can not find the one in your post.

/Kalyan Gutta

• ###### 8. Re: How to calculate Subtotals and Grand total by average since values are % values (not by using Analysis=>Totals)

Hey Kalyan,

I have attached it to the original post.

You do one thing, open the question in a new window completely. then you'll be able to find. Never mind,I'm attaching again. Open it in separate Window.

Hope this helps you. Let me know!

Thanks

Rahul

1 of 1 people found this helpful