Pivot Grand total on Selected columns only
 

Guys,
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+
FieldD).=FieldE.

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
GrandTotal..
thank u in advance
Dim