Is it possible to do conditional statements in pivot tables?

%3CLINGO-SUB%20id%3D%22lingo-sub-1514741%22%20slang%3D%22en-US%22%3EIs%20it%20possible%20to%20do%20conditional%20statements%20in%20pivot%20tables%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1514741%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20it%20possible%20to%20do%20conditional%20statements%20in%20a%20pivot%20table%3F%26nbsp%3B%20All%20I%20can%20find%20when%20Googling%20is%20conditional%20formatting%20which%20is%20not%20what%20I'm%20after.%26nbsp%3B%20I%20have%20an%20Excel%20report%20that%20displays%20student%20grades%20for%20various%20courses.%26nbsp%3B%20In%20my%20pivot%20table%20I%20want%20to%20only%20display%20those%20grades%20that%20are%20at%2080%25%20or%20higher.%26nbsp%3B%20Can%20anyone%20point%20me%20in%20the%20right%20direction%20please%3F%26nbsp%3B%20Even%20some%20links%20would%20be%20helpful.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1514741%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1515317%22%20slang%3D%22en-US%22%3ERe%3A%20Is%20it%20possible%20to%20do%20conditional%20statements%20in%20pivot%20tables%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1515317%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F431226%22%20target%3D%22_blank%22%3E%40Run4it530%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWorkaround%20is%20while%20inserting%20the%20Pivot%20Table%2C%20on%20Create%20Pivot%20Table%20Window%2C%20check%20the%20CheckBox%20at%20the%20bottom%20which%20says%20%22%3CSTRONG%3EAdd%20this%20data%20to%20the%20Data%20Model%3C%2FSTRONG%3E%22%2C%20refer%20to%20the%20following%20screenshot%20and%20then%20in%20the%20Pivot%20Table%20Field%20List%2C%20right%20click%20on%20the%20Table%20Name%20and%20choose%20Add%20Measure%20and%20Add%20a%20Measure%20as%20per%20the%20second%20screenshot%20and%20click%20OK%20to%20finish.%3C%2FP%3E%3CP%3EOnce%20a%20Measure%20called%20Above%2080%25%20is%20created%2C%20you%20may%20add%20this%20measure%20to%20the%20Values%20area%20to%20get%20the%20Pivot%20Table%20in%20the%20desired%20format.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Create%20PivotTable.jpg%22%20style%3D%22width%3A%20387px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F204662iA91C12E6C28F3687%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Create%20PivotTable.jpg%22%20alt%3D%22Create%20PivotTable.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdd%20Measure%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Measure.jpg%22%20style%3D%22width%3A%20997px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F204664iF074BC36FBA266B4%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Measure.jpg%22%20alt%3D%22Measure.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAnd%20the%20resultant%20Pivot%20Table%20would%20look%20like%20this...%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Grades%20Above%2080%20pct.jpg%22%20style%3D%22width%3A%20337px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F204670iC929FB1CDC16AF3D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Grades%20Above%2080%20pct.jpg%22%20alt%3D%22Grades%20Above%2080%20pct.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EPlease%20refer%20to%20the%20attached%20for%20more%20details.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Is it possible to do conditional statements in a pivot table?  All I can find when Googling is conditional formatting which is not what I'm after.  I have an Excel report that displays student grades for various courses.  In my pivot table I want to only display those grades that are at 80% or higher.  Can anyone point me in the right direction please?  Even some links would be helpful.

1 Reply
Highlighted

@Run4it530 

Workaround is while inserting the Pivot Table, on Create Pivot Table Window, check the CheckBox at the bottom which says "Add this data to the Data Model", refer to the following screenshot and then in the Pivot Table Field List, right click on the Table Name and choose Add Measure and Add a Measure as per the second screenshot and click OK to finish.

Once a Measure called Above 80% is created, you may add this measure to the Values area to get the Pivot Table in the desired format.

Create PivotTable.jpg

 

Add Measure:

Measure.jpg

And the resultant Pivot Table would look like this...

Grades Above 80 pct.jpg

Please refer to the attached for more details.