Forum Discussion
How to make one pivot with data from different sheet
I have tried to make one pivot from different sheet in excel but I didn't understand how can do that in this file in the Sheet STAT I have tried to import in one pivot all the data but now don't know how to do now because the information are not merged look like I can make different pivot not one.
what I need to do is one pivot filtered by (A, AA, AB, AC, etc) for the different "current status" column counting the document
and an other one filtered by (A, AA, AB, AC, etc with the column next issue date.
- is the Sheet STAT is the raw data?
Do you want some data clean or ETL (extract trasform and load)?
What is the expected result?the STAT sheet is a draft where I have created different pivot form the different sheet but now I have 15 pivot and for the chart I had to make an other schedule with all the data from the pivot. Is not useful.
The result if is possible is to have one pivot, as all the sheet have the same column name, where I can have a filter that allow me to change the section (A, AA; AB, AC etc) and the list of the different data form the Current status column. from this pivot I can make the chart.
I have tried to join all the sheet in one pivot (you can see the starting of the pivot under the 15 different) but I don't know how to merge all the data in one
- have tried to join all the sheet in one pivot
Yes,I know you want to merge all datas to a list which can back support one pivot analysis table analysis.
I supposed you know the format of the backend list I mentioned above which is transfered from the sheet STAT.
But now,you mentioned multiple raw sheets,I am lost.
If you provide some raw datas and expected result in detail,it maybe helpful to understand what you want to do.
