Report derive from Pivot table

User avatar
PRADEEPB270
3StarLounger
Posts: 348
Joined: 27 Oct 2013, 15:11
Location: Gurgaon INDIA

Report derive from Pivot table

Post by PRADEEPB270 »

Hi Gentlemen,

Please refer my attachment for better explanation.

I want a required format report from PIVOT table but every times ,I apply a lot of excel formulaes.

Is there any solution from this cumbersome excercise.
My final report is in Column H to K ,which is derived from Pivot.

How can we populate the same date in Pivot or can we easy to derive ?
You do not have the required permissions to view the files attached to this post.
Regards

Pradeep Kumar Gupta
INDIA

User avatar
HansV
Administrator
Posts: 71978
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Report derive from Pivot table

Post by HansV »

This might well be done with PowerPivot and/or PowerQuery. I hope that someone else can help you with that.
Regards,
Hans