Dynamically Connecting Data from one sheet to another

Question

Hello,&nbsp;I am looking to have data taken from one workbook to another. Each column having different option have dynamic totals in another sheet. I am having a hard time connecting the data and just to be creating pivot tables that do not update. Please help.&nbsp;&nbsp;I am looking at the the Shape, Color, Size columns to data inputted dynamically into another sheet.&nbsp;

sergeibaklan · Answer

DavidM21&nbsp;
That's too abstract question, desirably to have the file which illustrates it.

davidm21 · Answer

I have added a spreadsheet as an example.

yea_so · Answer

Hi&nbsp;DavidM21,&nbsp;Using Power Query, flatten your dataset table (meaning unpivot them) so you can feed the flattened dataset to the data model and be able to create a dynamic power pivot in real time (upon refresh all).&nbsp;Cheers

davidm21 · Answer

Yea_So&nbsp;&nbsp;Thank you for that! How would I upivot them? I see the refresh option to allow update stats but not unpivot.&nbsp;&nbsp;&nbsp;

yea_so · Answer

Hi DavidM21,Here is an article describing the process:https://www.linkedin.com/pulse/leveraging-power-query-data-model-create-dynamically-pivot-torralba/?trackingId=cDnh9lz5av8674ji06mWrA%3D%3DPlease don't hesitate to reach out if you have any questions.cheers

Forum Discussion

Dynamically Connecting Data from one sheet to another

5 Replies

Resources