April 12, 2022
See the attached image.
I'd like to
-sum the February related columns in a new column "Total Feb'22" and
-sum the March related columns in a new column "Total Mar'22"
I can do this with calculated items in normal pivot table but it is greyed out when I try to do it in a pivot table from power pivot data model.
I'd really appreciate if anyone has a solution to this.
July 16, 2010
Welcome to our forum! I think Named Sets can help you.