Resolution
Scenario 1: Grand totals are blank for the discrete measure
Recreate the view using Measure Names and Measure Values. The attached example workbook starts from the worksheet "Scenario 1" to demonstrate the following directions. Find the attached example workbook to the right of this article under the "Attachments" section.
- Remove Profit Ratio from the Rows shelf.
- Double-click Profit Ratio in the data pane.
- Tableau Desktop automatically moves both measures to the Measure Values card and adds Measure Names and Measure Values to the view.
Scenario 2: Error "Cannot turn on Grand Totals for discrete measures"
Convert the discrete measure to the dimension. The attached example workbook (to the right of this text in the Attachments section) starts from the worksheet "Scenario 2" to demonstrate the following directions:
- Select Analysis > Create Calculated Field.
- In the Calculated Field dialog box that opens, do the following, and then click OK:
- Name the calculated field. In this example, the calculated field is named "Profit Ratio (LOD)"
- In the formula field, create a calculation similar to the following:
- { FIXED [Segment] : [Profit Ratio] }
- Right-click Profit Ratio (LOD) in the data pane and select Convert to Dimension.
- Replace Profit Ratio (table calc) with Profit Ratio (LOD) on the Rows shelf.
- Navigate to Analysis > Totals > Show Row Grand Totals.