I have attached file
the first sheet existing
the second sheet desired with pivot table
In manage data model i have added CaculatedColumn with formula =[Award]>0
The adding of this column is not recorded in record macro of excel
I want to add this column by VBA