multiple sheets data by PIVOT TABLE problem presentation

[majidsiddique]

Hi All,
i need your help to solve this. i am using Pivot Table to calculate each column data separately calculated. i want to show each column data with different sheets ranges are same by pivot table. i convert table and apply pivot but when i use table name first table and select option Total. first table data show perfect second table data not perfect. same this, i want to show 7 table data at a time by pivot.

hope you understand.

please review file.


Thanks.

[zzzeddy]

Hi

That pivot table wasn't created in Excel2010.

But you can retrieve the data you want by simple formulas

..see attached file with sheet [zeddy]

[majidsiddique]

Thanks zzzeddy,
i know this but i want to do it by PIVOT TABLE. can you tell me in which excel version is available this feature?

Thanks

[JeteMc]

Perhaps this will help.
A column is added to the individual source data tables, not the pivot tables, and is populated with the month in which the data is taken.
The tables are appended using Power Query (I assume from the file attached to post #1 you have that) and placed in the data model.
A pivot table is produced using the data model with column 1 and names in the rows field, month (new column) in the columns field and total in the values field.
Let us know if you have any questions.

[majidsiddique]

Its working perfect JETEMC,
thanks a lot, really cheer,
can you please tell me, you add column M for month, is it necessary for this?

[majidsiddique]

Can you please tell me how to merge by power query with all month data?
see this snap power query. i am connecting my sheet but failed to merge month column.

[majidsiddique]

Thanks JeteMC
i understand by this power query.
Thanks a lot
its cheers

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.