<div>
I assume you mean the XID since E_NAME is showing? There is no direct way to do it within the subtotal function, but if you don't include an aggregate function for that column (so you get a blank cell rather than 0), you can then select the column once the subtotals are in place, press f5, click Special..., choose Blanks and OK. This will select the empty cells in the subtotals rows. You may then type = and press the up arrow once, then press Ctrl+Enter together.
</div>


I assume you mean the XID since E_NAME is showing? There is no direct way to do it within the subtotal function, but if you don't include an aggregate function for that column (so you get a blank cell rather than 0), you can then select the column once the subtotals are in place, press f5, click Special..., choose Blanks and OK. This will select the empty cells in the subtotals rows. You may then type = and press the up arrow once, then press Ctrl+Enter together.

<div>
Sorry i actually typed it in because i was thinking it, bu basically i want to get a subtotal grouped on multiple fields. Is that possible?
</div>


Sorry i actually typed it in because i was thinking it, bu basically i want to get a subtotal grouped on multiple fields. Is that possible?

<div>
<div class="content wysiwyg-content">
Hi, I have the following data<br />
&nbsp;<br />
MYMONTH &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;E_NAME &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;XID &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;IS_LOCAL &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TTLVOL <br />
2013-11 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Employee x &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ESX &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;18,800 <br />
2013-11 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Employee x &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ESX &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;0 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; - &nbsp; <br />
2013-11 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Employee x &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ESX &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1,110,200 <br />
If i use subtotal on the data i get<br />
<br />
MYmonth &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;E_Name &nbsp; XID IS_LOCAL ttlvol<br />
Employee X Total 0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0 &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; 1,129,000<br />
<br />
Is there another function that i can use to get the e_name to show up rather than 0?
</div>
</div>


Hi, I have the following data
 
MYMONTH	E_NAME	XID	IS_LOCAL	 TTLVOL 
2013-11	Employee x	ESX	0	 18,800 
2013-11	Employee x	ESX	0		 -   
2013-11	Employee x	ESX	1	 1,110,200 
If i use subtotal on the data i get

MYmonth              E_Name   XID IS_LOCAL ttlvol
Employee X Total 0               0      0       1,129,000

Is there another function that i can use to get the e_name to show up rather than 0?

Excel grouping with subtotal

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.