How to prepare a pivot table s per this Excel table format

[nevilledhamsiri]

Hi;

Dear all,

The attached excel table carry data for Month actual, Month budget , Month variance YTD Actual ,YTD Budget & YTD Variance. I can load this data & arrange the dimensions as under the description field. My requirement is to arrange the above expressions as in the given format in a pivot table. Can any body guide me as to how this could be achieved?.

Thanks 

Neville

[nevilledhamsiri]

Dear Community Members,

Appreciate if some one help me out on this

[nevilledhamsiri]

Can any one responds to this please

Neville

[Brett_Bleess · Accepted solution]

Best I can do for you is point you in some right directions that may help:

Design Blog area:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Pivot Table help:

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Pivot_Table.h...

Training area:

https://www.qlik.com/us/services/training

Sorry I do not have anything better, but hopefully this may help you move things forward if you are still struggling.

Regards,
Brett

[nevilledhamsiri · Accepted solution]

Dear Brett,

Thanks for your assistance which helps me to resolve some issues. But my issue looks somewhat