Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
160
Views
Topic starter
Hi expert,
Iwant to do this model .
I have five factory and evry factory have alot of products
Iwant to display evry factory alone at one model by slicer or eny tool
Regards
Posted : 11/04/2017 6:49 am
Hi Mey,
Unfortunately the 'All Data' worksheet is not in the ideal layout for working with the built in tools that make this task easy e.g. Slicers and PivotTables.
I highly recommend you fix the data layout so it's in a Tabular format. From there you can use PivotTables and Slicers to quickly and easily generate your reports.
Mynda
Posted : 11/04/2017 8:03 am
Topic starter
Thanks
Posted : 11/04/2017 6:21 pm