Hi

This is Ken.

I am trying to create a database to do some sales analysis

I am using pivot to create my database but i can't average
it in my pivot base on 3 month, 4 month, 5 month, 6 month

For example, below is my raw data

excel1.jpg

I wish to pivot it like below. Is that possible ?

excel2.jpg

Hope someone can advise me.


Thanks

Ken