Forum Discussion
Is it possible to do conditional statements in pivot tables?
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
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.
Add Measure:
And the resultant Pivot Table would look like this...
Please refer to the attached for more details.
