totals & subtotals

[dseelam]

Hello All,

attached image is a pivot table fully expanded with units and sales $ as expressions when I move units and dollars separated manually and apply partial sum on LFT Account name this yellow marked totals are coming up how to avoid them?

Is this a bug of some kind

[dseelam · Accepted solution]

yes I found it the yellow colored row is nothing but month year has been converted in to num(date) 

I did a simple date format trim(date(field),mmm-yyyy)