Loading

Unable to Filter the View Without Changing Grand Totals

Udgivelsesdato: Apr 23, 2025
Beskrivelse
You are unable to keep the same grand total when filtering the view. 
Løsning
This example uses Superstore sample data to show the grand total of Sales by State. The below solution can be reviewed in the attached workbook. 
  1. Select Analysis > Create Calculated Field
  2. Name the calculation grandtotal.
  3. Enter the following formula, then click OK:
    IF SIZE() = 1 THEN ATTR({FIXED Country : SUM([Sales])})
    ELSE SUM([Sales])
    END 
  4. Place State on Rows 
  5. Place grandtotal on Text
  6. Right-click State and select Show Filter
  7.  Select Analysis > Totals >  Show Column Grand Totals

You can now filter on State, while keeping the grand total the same. To view these steps in action, see the video below:
Note: the video has no sound 

Yderligere ressourcer
This method can be used to conditionally color the grand totals column as well.

Vidensartikelnummer

001473368

Vedhæftede filer

customgrandtotal.twbx

1242 KB

 
Indlæser
Salesforce Help | Article