Power Query
July 15, 2023
I have a set of manufacturing data where I have initial % Concentration and Final % Concentration values. The lab data comes in with all of the labs for every item number.
I would like to be able to use slicers to select customer and item number, then show the "Time Series" data, not the "summation" or the "Average" I would like the actual values graphed over time, but customer and item selected by slicers.
Eventually, I would like to show the "Start" vs. the "Final" % concentrations, but I'll be happy with the slicers producing individual data, not the summary stats.
Any help? Any tutorials available?
Thanks in Advance
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Hi Rob,
You have to aggregate the source data using Power Query, the output should be a pivot table/chart.
PQ: https://www.myonlinetraininghu.....ower-query
Organizing the pivot table according to your desired structure: https://www.myonlinetraininghu.....ivot-table
Answers Post
1 Guest(s)