Change the value field settings to show the calculated values as a percentage of the Grand Total.

Your "Subtotal" field is showing as left aligned and without a currency symbol. What is likely the issue?Select an answer:The field is formatted as a percent.The field is formatted as text.The field is formatted as a number.

True or false? In the Subtotal dialog box, if the Summary below data box is unchecked, the Grand Total and Subtotal appear above the data.Group of answer choicesTrueFalse

A product has an updated weight value after a manufacture change, and the inventory report has an inconsistent total value for the calculated "Cost" field. What should be performed to resolve the issue?Select an answer:Create a calculation that subtracts the total value from the expected value.Confirm the calculation is updated to reflect the change.Create a calculation that subtracts the updated weight value from the calculated cost field.Create a calculated field that captures the difference between the total and expected value.

Question 3Which of the following methods would enable me to show the Count instead of the Sum of Total?(Multiple answers are possible. Partial credit will be awarded)1 pointRight-click on any cell under the Sum of Total field and go to Show Values As and choose Count.Right-click on any cell under the Sum of Total field, go to Summarize Values By and change it to Count.Drag a text field into Values area and remove the Total field.Right-click on any cell in the Sum of Total field and going to Value Field Settings and under Summarise Values By, find Count.

The third group (Calculations) must include four (4) worksheets:• one (1) worksheet to calculate each ratio (2 ratios in total: Calculation 1 and Calculation 2);• one (1) worksheet to calculate revenue budget variance (labelled as ‘Calculation 3’); and• one (1) worksheet labelled ‘Additional Calculations’ in which you include any other calculations(e.g. calculations used in the 4th dashboard panel).Do not forget to appropriately use cell referencing in your calculations.One of the ratios should be ‘sales growth’ regarding quantity. You must obtain the sales growth ratiousing Pivot Tables and CALCULATED FIELDS. In terms of the second ratio, there is no prescription, soyou need to decide which ratio to use. However, you must use Excel formulas to calculate the value(s).In the ‘Calculation 3’ worksheet, you must calculate budget (sales revenue) variance for each shop.Information on budgeted sales revenues is provided in the ‘Actual & Budget’ worksheet. Additionally,you must include a chart and/or table about Actual and Budgeted data in the dashboard report. Becreative!You must use at least two (2) Pivot Tables in your calculations.