Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)))
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)))
Thanks!