Sorry i don't know how to word it right.
My question is, how do I make that green tip in pic? If I drag down that tip it will create new rows, but it'll also copy all of the formats, date, data validation, etc from above tables. The grand total below will gets auto calculated when I put new data in the new rows, pivot data range also gets automatically updated.
How do I create this format? Currently I always insert new row and do manual update in pivot data range. pain
My question is, how do I make that green tip in pic? If I drag down that tip it will create new rows, but it'll also copy all of the formats, date, data validation, etc from above tables. The grand total below will gets auto calculated when I put new data in the new rows, pivot data range also gets automatically updated.
How do I create this format? Currently I always insert new row and do manual update in pivot data range. pain