That is what I thought but the pivot table has been helpful for the database
created.
Thanks

"ShaneDevenshire" wrote:

Hi Jo,

I would suggest you do this outside a pivot table using formulas. Inside a
pivot table requires ALL kind of gyrations.

--
Thanks,
Shane Devenshire


"Jo" wrote:

I would like my pivot table report to have only daily information and the MTD
information.

Example
Customer 09/23 MTD
A 100 2000
B 200 5000
Total 300 7000

Does anyone know how to accomplish this?