Back to lesson
1. Which statement is false with regards to using Calculated Items?
Calculated fields allows expansion/collapsing like regular grouping levels.
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.
2. 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 …
… but when you get there you find the option is unavailable because you need to select a row item first.
… 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.
… 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.
3. 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?
You need to drag it on to the PivotTable from the field list.
You need to refresh the PivotTable first, then drag it on to the PivotTable from the Item list.
None, it is added automatically.
Back to the top
© 2018 GoSkills Ltd.
Skills for career advancement