I have a file contain 3 sheets,name-Plant-1,plant-2 and plant-3 with their 3 pivot table also.The datas is so large.It is possible that each plant wll have 900000 rows approxmately in a financial year.Is it possible to summarize all the 3 plants datas into one summary sheet instead of 3 pivot tables?The datas should contails all the vaues and fields as it appear in pivot table form.
Is there any excel formula or pivot table form or best way to present the whole datas into the convenient way?
For more clarification,please refer attach file.
Bookmarks