-
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
-
-
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
-
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
-