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
Bookmarks