locked
Adding an Aggregate Group in Power Query RRS feed

  • Question

  • Hi all,

    I'm looking for what I'm sure has a fairly simple solution but can't quite figure it out. 

    I currently have data set of cases summarized by region and the order in which each case completed a test (the regions being North, East, West South).

    I've got the pivot table broken out by region, grade and order, but I'm just looking for a way to add an aggregated row at the end (found on the "DesiredResult" tab in the attached workbook) that will create a total count for the grades.

    SampleWorkBook

    Monday, September 17, 2018 5:03 PM

Answers

All replies