Total function

Q&A
, , , , , , ,
2

Hi @juditliz, you can use calculated fields to aggregate the data and display the total in the specific column. Here’s a step-by-step guide to help you accomplish this:

Step 1: Create a Calculated Field for TotalObUnits

  1. Open your dataset in QuickSight.
  2. Create a new calculated field. Name it something like TotalObUnits_Week24.
  3. Use the following formula:

Pseudocode (Syntax may vary)

ifelse({week_number} = 24, {TotalObUnits}, 0)

This formula ensures that the TotalObUnits values are considered only for week 24.

Step 2: Aggregate the Calculated Field

  1. Create another calculated field to sum the values from the previous step:

Pseudocode (Syntax may vary)

sumOver({TotalObUnits_Week24}, [{week_number}])

This will give you the total of TotalObUnits for week 24.

Step 3: Display the Total in the Desired Column

  1. Add the calculated field to your analysis.
  2. In your visual, place the calculated field (created in Step 2) in the RatePack column.
  3. Adjust the visual settings to ensure it displays the total only for the row where process_name = Pack Support. You can do this by applying a filter or using conditional formatting.

Example Implementation:

  1. Calculated Field for Week 24 Total:

Pseudocode (Syntax may vary)

TotalObUnits_Week24 = ifelse({week_number} = 24, {TotalObUnits}, 0)
  1. Aggregated Calculated Field:

Pseudocode (Syntax may vary)

SumTotalObUnits_Week24 = sumOver({TotalObUnits_Week24}, [{week_number}])
  1. Add SumTotalObUnits_Week24 to your visual.
  2. Apply Filters and Conditional Formatting as needed to ensure the total displays only for Pack Support or across the desired row.

By following these steps, you should be able to display the sum of TotalObUnits for week 24 in the RatePack column, either for the Pack Support row or the entire row as per your requirement.

Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!

In case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and post it here. (Details on using Arena can be found here - QuickSight Arena)