-
1. Re: How to calculate Subtotals and Grand total by average since values are % values (not by using Analysis=>Totals)
Ashish Chaudhari Oct 24, 2016 2:42 AM (in response to Kalyan Chakravarthi Gutta)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
-
Subtotals.twbx 24.1 KB
-
-
2. Re: How to calculate Subtotals and Grand total by average since values are % values (not by using Analysis=>Totals)
Kalyan Chakravarthi Gutta Oct 24, 2016 3:05 AM (in response to Ashish Chaudhari)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)
Ashish Chaudhari Oct 24, 2016 3:14 AM (in response to Kalyan Chakravarthi Gutta)2 of 2 people found this helpfulHi 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.
-
4. Re: How to calculate Subtotals and Grand total by average since values are % values (not by using Analysis=>Totals)
Rahul Verma Oct 24, 2016 3:22 AM (in response to Kalyan Chakravarthi Gutta)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
-
Kalyan.twbx 22.6 KB
-
-
5. Re: How to calculate Subtotals and Grand total by average since values are % values (not by using Analysis=>Totals)
Rahul Verma Oct 24, 2016 3:24 AM (in response to Rahul Verma)1 of 1 people found this helpfulIn 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 itRegards
Rahul
-
6. Re: How to calculate Subtotals and Grand total by average since values are % values (not by using Analysis=>Totals)
Ashish Chaudhari Oct 24, 2016 3:29 AM (in response to Kalyan Chakravarthi Gutta)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)
Kalyan Chakravarthi Gutta Oct 24, 2016 3:46 AM (in response to Rahul Verma)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)
Rahul Verma Oct 24, 2016 3:52 AM (in response to Kalyan Chakravarthi Gutta)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
-
Kalyan.twbx 22.6 KB
-