Pivot table

%3CLINGO-SUB%20id%3D%22lingo-sub-2760165%22%20slang%3D%22en-US%22%3EPivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2760165%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone!%3CBR%20%2F%3E%3CBR%20%2F%3EThere%20is%20a%20problem%20with%20pivot%20table%20function%2C%20doesnt%20show%20me%20correctly%20data%20from%20another%20sheet.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20divided%20sheets%20by%20responsible%20people%20including%20tasks%20names%2C%20responsible%20name%20and%20their%20statuses%20and%20more%20additional%20information.%20I%20need%20summarize%20it%20in%20the%20another%20sheet%20with%20only%20resp.name%2C%20task%20name%20and%20status%2C%20but%20only%20certain%20statuses.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20did%20through%20special%20insert%2C%20pivot%2C%20but%20shows%20me%20incorrectly%20with%20lot%20of%20zeros%20or%20crooked...%3CBR%20%2F%3E%3CBR%20%2F%3EHave%20any%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2760165%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2761311%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2761311%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1158969%22%20target%3D%22_blank%22%3E%40daniyarbayakhanov%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIs%20it%20possible%20to%20share%20sample%20file%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2761386%22%20slang%3D%22en-US%22%3ERe%3A%20Pivot%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2761386%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bthere%20is%20a%20sample.%3CBR%20%2F%3EIn%20the%20sheet%20Summary%20have%20to%20included%20lines%20from%20another%20sheets.%20But%20for%20example%20in%20Summary%20have%20to%20be%20only%20tasks%20with%20status%20%22done%22.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello everyone!

There is a problem with pivot table function, doesnt show me correctly data from another sheet.

I have divided sheets by responsible people including tasks names, responsible name and their statuses and more additional information. I need summarize it in the another sheet with only resp.name, task name and status, but only certain statuses.

I did through special insert, pivot, but shows me incorrectly with lot of zeros or crooked...

Have any ideas?

6 Replies

@daniyarbayakhanov 

Is it possible to share sample file ?

@Sergei Baklan there is a sample.
In the sheet Summary have to included lines from another sheets. But for example in Summary have to be only tasks with status "done".

@daniyarbayakhanov 

Thank you.

 

First, I'd recommend to keep data in structured tables. It's easy to add and transform data, easier to support.

 

In general that's task for Power Query - query each table, by another query combine them together, remove not needed columns and load back into the grid. Result is like

image.png

@Sergei Baklan Thanks!
Did some thinks how to combine 3+ sheets in one.
Completed task

do you know about how in excel online refresh data?
I did uploaded pivot table and cannot to refresh data from other sheets..

@daniyarbayakhanov 

Don't know exactly and didn't check right now, but If you don't use Power Query when PivotTable based on other sheets data (not other workbooks) shall be refreshable. Power Query is not refreshable.