How to add new columns in a Pivot table developed using BI Publisher extension.

The requirement is to add calculation columns like Average and Variance in a BIP RTF template which has a pivot table. The calculation columns need to added after the pivot columns. I am able to add these columns at the beginning of the report but not towards the end of the report.

Any suggestions/inputs are much appreciated regarding this.

Thank You