Any way I can omit this section in a pivot table but keep the 2021 Total?
You can't truly omit those rows and still show the total, but you can click the minus sign next to 2021 which will collapse those rows keep the detail from showing. If you do this in analyzer, it will save as the default setting for the viewer of the card.
One of the most frustrating features of DOMO. Other BI systems I use auto compress rows like this.
