5 Replies Latest reply on Aug 31, 2016 4:42 AM by shiva chary

Need 2- Grand totals at the end( ie. July & Jun - grand totals)

shiva chary Aug 31, 2016 12:17 AM

Hi All,

Iam pretty new to Tableau.

i need July and June Grand totals at the end.

ie.. for July = 225+643+411+1582+14+360+49+359... top row forexample

canany one share the help on this.

Since this is confidential data, i couldnot attach the file.

You might consider any header or any data... buteach category has 2months , and need grand totals month wise.

i need like below : 2 totals at the end - month wise

Any one help please , i have around 100 tables to do such calculations

1. Re: Need 2- Grand totals at the end( ie. July & Jun - grand totals)

Mahfooj Khan Aug 31, 2016 12:52 AM (in response to shiva chary)
You have do something like this. In one sheet your state wise category sales and in another sheet only category wise sales for Jun and July. Hide the Category header from second sheet and add a dummy header for Grand Total. See the screen shot.
Workbook (version 9.3) attached for your reference. go through the below links which may help you to understand more about grand totals.
Customizing Grand Totals – Part 1 | Drawing with Numbers
Customizing Grand Totals – Part 2 | Drawing with Numbers
Customizing Grand Totals – Part 2 | Drawing with Numbers

Feel free to ask If you've any query.

Mahfooj

Grand Total.twbx 1.2 MB
Like Show 1 Likes(1)

Actions
2. Re: Need 2- Grand totals at the end( ie. July & Jun - grand totals)

shiva chary Aug 31, 2016 1:14 AM (in response to Mahfooj Khan)

Great ... Thank you somuch for your qucik answer...

the problem is in a dashboard i have around 10 tables , and relateed filters ..which itself occupying the entire view.

Also i have around 100 tables to make such changes...and around 30 to 40 dashboards...

The solutions is OK ,, but have to create 100 additional totals for 100 tables...

anyother alternate solution please
Like Show 0 Likes(0)

Actions
3. Re: Need 2- Grand totals at the end( ie. July & Jun - grand totals)

shiva chary Aug 31, 2016 1:47 AM (in response to Mahfooj Khan)

Hi Mahfooj ,
Iam not able to hide row categories in my case, can you please help?
need to hide souce and gender... as per your earlier solution.

But this will be a mere help for me...need some thing different solution
Like Show 0 Likes(0)

Actions
4. Re: Need 2- Grand totals at the end( ie. July & Jun - grand totals)

Mahfooj Khan Aug 31, 2016 2:16 AM (in response to shiva chary)

Just uncheck show header option from the fields.
If you can mockup some sample data similar to your original data then me or someone from the community can analyse your issue and will try to give some other solution. You don't need to send actual data you just modify and send some dummy data.
Like Show 0 Likes(0)

Actions
5. Re: Need 2- Grand totals at the end( ie. July & Jun - grand totals)

shiva chary Aug 31, 2016 4:42 AM (in response to Mahfooj Khan)
Hi Mahfooj ,
Thank you for your reply ,
Please Find the attachment. : Book1.twbx

Belowsnapsho is from excel :

I want Totals at the end as explained earlier.

Also Conditionally format cells based on th cirteria given.

Can any one helpme on this please...

Book1.twbx 522.8 KB
Like Show 0 Likes(0)

Actions