Back to School Sale -
20% off all courses with code BTS2019
Search for courses or lessons
Redeem a coupon
Start free trial
Which statement is false with regards to using Calculated Items?
To avoid double counting in your PivotTable you must filter out the items that contribute to a Calculated Item, as the original items are included in totals and subtotals along with the original items.
Calculated fields do not automatically update when new data is added to the PivotTable.
Calculated fields allows expansion/collapsing like regular grouping levels.
You have the PivotTable shown below and decide to set up a Calculated Item to group the Burger and Sandwiches items from the Categories field. You select a cell in the values area, go to the PivotTable Tools > Analyze (Options tab in 2010) > Fields, Items and Sets …
… you click Calculated Item, provide a name for the new item, click in the formulas area, select the Category on the left and then choose all the sales items you’d like to include.
… but when you get there you find the option is unavailable. Instead you select the names Burgers and Sandwiches on the left side of the PivotTable, right click them and choose Group.
… but when you get there you find the option is unavailable because you need to select a row item first.
Assume that you have just created a new Calculated Item for your PivotTable. What steps need to be taken to actually add it to the PivotTable?
None, it is added automatically.
You need to refresh the PivotTable first, then drag it on to the PivotTable from the Item list.
You need to drag it on to the PivotTable from the field list.