July 6, 2022
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.
February 13, 2021
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.