Trend Graphs from Large Data Sets

%3CLINGO-SUB%20id%3D%22lingo-sub-2761302%22%20slang%3D%22en-US%22%3ETrend%20Graphs%20from%20Large%20Data%20Sets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2761302%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%20a%20large%20data%20set%20and%20I%20need%20to%20show%20the%20sales%20performance%20(both%20RRP%20and%20sales%20price)%20trend%20for%20Jan-Dec%202020%20in%20a%20graphical%20format.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20need%20to%20show%20in%20a%20table%20how%20many%20sales%20were%20completed%20where%20the%20client%20bought%20more%20than%201%20product%20by%20month%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20this%20is%20probably%20simple%20to%20a%20lot%20of%20people%20but%20I'm%20struggling%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2761302%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2762988%22%20slang%3D%22en-US%22%3ERe%3A%20Trend%20Graphs%20from%20Large%20Data%20Sets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2762988%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1159246%22%20target%3D%22_blank%22%3E%40DanStaff82%3C%2FA%3E%26nbsp%3BPerhaps%20something%20like%20in%20the%20attached%20file.%20It%20contains%20two%20pivot%20tables%20and%20one%20pivot%20chart.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi, I have a large data set and I need to show the sales performance (both RRP and sales price) trend for Jan-Dec 2020 in a graphical format. 

 

I also need to show in a table how many sales were completed where the client bought more than 1 product by month?

 

I know this is probably simple to a lot of people but I'm struggling

 

Thank you

1 Reply

@DanStaff82 Perhaps something like in the attached file. It contains two pivot tables and one pivot chart.