Loading

How To Fetch Columns Value With Minimum Grand Total

Date de publication: Apr 30, 2025
Tâche

How to fetch columns value with minimum grand total. Example: Retrieve the lowest category column for different segments

Étapes
1. Create a calculated field Column total in view with the following formula:
 WINDOW_SUM(SUM([Sales]))

2. Create another calculated field Minimum across the column total with the following formula:
WINDOW_MIN([Column total in view])

3. Drag Column total in view to Detail on Marks card and Choose compute using Table Down

4. Drag Minimum across the column total to Detail on Marks card and Choose compute using Table Across

5. Create another calculated field Is grand total min? with the following formula:
[Column total in view]=[Minimum across the column total ]

6. Drag to Filters Shelf and select True
Numéro d’article de la base de connaissances

001456847

Pièces jointes

Solution.twbx

1226 KB

 
Chargement
Salesforce Help | Article