qlikview how to achive the requirement?

[wangxusq]

Hi all,

I have a requirement, see the below pictures.

My cus wants to export the all data at one time,now he need the pivot table included the Year  Month city and other dimesions.He also need the MoM and YoY. Owning to the script is complex, so I only  achive the quirement by Expression. Year field may have many many value.How can I to do this?

That is  how I achive the Mom and YoY? Need the below picture:

[sergio0592]

It's a little fuzzy. What is the meaning of MoM and YoY. What are the associated expressions that you have made and what is the expected output?

Regards