Search for courses or lessons
Redeem a coupon
Start free trial
Which statement is false with regards to using Calculated Items?
Calculated fields do not automatically update when new data is added to the PivotTable
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 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
Back to the top
© 2020 GoSkills Ltd.
Skills for career advancement