need a little help with row grand total :

my tbl :
columns as dates (about a week or two ) ,
each day has 4 data fileds (fieldA, FieldB, fieldC, FieldD)+ extra
field (field E)
which is sum of first 4 fields (fieldA+ FieldB+ fieldC+

i need to find a way of showing Grand total (rows) which sum up ONLY
FieldE. for each visible day without adding the first 4 fields.. does
not matter how: eigher through VBA or as some sort of calculate
thank u in advance