I am building Pivots on the fly all works well but, how do turn off or remove
the row totals at the moment I have to right click and hide is there a way to
do this when my code builds the pivot.
TIA
Frank