Pivot table wizard into Data Model - how to do so? The set reflects a Boolean relationship. Now click the Fields, Items & Sets button. I simply want to create a calculated field (Capacity - Work)---but when I do as instructed--click "Fields, Items, and Sets" (under Pivot Table Tools), the "Calculate Field" command is greyed out. the to… To create a Set, click into your PivotTable and then click the Ribbon’s Analyze tab ( Options tab in older versions). When I auto filter a spreadsheet, I can't figure out how to delete or eliminate from the sheet the filtered-out rows. The default was always set to copy everything (including hidden cells), unless I specifically selected copy visible cells only. Meaning if Slave_1's value is 1 then the