How to display expression value only at subtotal level in pivot table.

[abc_18]

Hi,

I have one expression field Variance%

Formula is :- Variance%= EAC-Budget / Budget.

in this image I have budget data only for Vendor C, so for that that row variance is -100%.

My requirement is how to get that variance value only at subtotal level, that is only -74% should display in report.

[abc_18]

Yes because I haven't selected any cost code to display subtotal value.

Only I have applied Dimensionality() formula.

[rubenmarin1]

Hi Shikha, I will need a sample to help yo check why the table with many codes doesn't show subtotals, usual behaviour will show a subtotal for each code... Is the same table?