Forum

Notifications
Clear all

Need Help on presenting mutli table into one pivot table or if there are other ways.

3 Posts
2 Users
0 Reactions
83 Views
(@eugene83)
Posts: 3
Active Member
Topic starter
 

Can someone recommend me what will be way to present a data that has the following requirement. 

Such as a pivot table. My skill level currently, i am able to create a pivot table based on just table of data

I do not know how to combine all to be able to show everything in one page to show table of data combine and individually in the current format.

I have attached a simple basic. please kindly advise.

 
Posted : 07/07/2022 3:38 am
(@jstewart)
Posts: 216
Estimable Member
 

I would use Power Query to combine the tables and then create a pivot table from the connection (Close and Load to... "Only create connection">Insert Pivot Table>Using External Connection>Choose connection to query). I added my pivot table just below yours and created a slicer for the Shop Site. Hope this points you in the right direction. If you don't know about Power Query, here is some information for you.

 
Posted : 07/07/2022 12:13 pm
(@eugene83)
Posts: 3
Active Member
Topic starter
 

Thank you Jessica, I will read up and that. Thank you for your help

 
Posted : 07/07/2022 11:31 pm
Share: