Pivot Tables and extracting data using Power Query Function

%3CLINGO-SUB%20id%3D%22lingo-sub-1567582%22%20slang%3D%22en-US%22%3EPivot%20Tables%20and%20extracting%20data%20using%20Power%20Query%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1567582%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EWorking%20in%20on%20a%20database%20and%20want%20to%20produce%20class%20lists%20with%20certain%20fields.%20All%20I%20can%20get%20at%20the%20moment%20is%20the%20report%20in%20a%20%22stacked%22%20format.%20What%20I'd%20like%20is%20to%20see%20the%20record%20in%20a%20row%20i.e.%20surname%2C%20forename%2C%20gender%20etc%20and%20then%20perform%20calculations%20on%20certain%20fields%20like%20gender.%20say%2C%20how%20many%20boys%20in%20the%20class.%20...%20and%20many%20others%20once%20I%20understand%20the%20basics.%20Many%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1567582%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Apps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello

Working in on a database and want to produce class lists with certain fields. All I can get at the moment is the report in a "stacked" format. What I'd like is to see the record in a row i.e. surname, forename, gender etc and then perform calculations on certain fields like gender. say, how many boys in the class. ... and many others once I understand the basics. Many thanks

0 Replies