Don't SubTotal Text Field?

[cbaqir]

I have a pivot table with several calculations and then a text based field for comments. I need to have subtotals enabled for the calculated columns but I don't want the comments fields to show at the subtotal level. How can I make those bolded comments not be displayed?

[krishnacbe · Accepted solution]

Hi,

Change the Variance Explanation formula as below.

=if(Dimensionality()=3,if(AU_NUM='100000',only({<[NOTE_TYPE] = {'MTD'},EXP_TYPE_CODE={'Capital'}>}NOTE),only({<[NOTE_TYPE] = {'MTD'},EXP_TYPE_CODE={'Operating'}>}NOTE)))

[cbaqir]

Thanks!