Loading

How To Keep Top 10 Sub-Category by Total Sales While Showing Percent of Total with Missing Data

Дата публикации: Apr 13, 2024
Задача
Top 10 data shows more than 10 records when using RANK(TOTAL(SUM([Sales]))) filter due to missing data.
This occurs when using [Percent of Total] in Quick Table Calculation.

User-added image

User-added image

User-added image
Действия
1. Create following calculation 

[WINDOW_AVG]

WINDOW_AVG(TOTAL(SUM([Sales])))

[RANK]

RANK(WINDOW_AVG)

2. Drag [RANK] to [Filter]

3. Right click on [RANK] -> [Edit Table Calculation]

Set Nested Calculations as bellow
[RANK] : Table (down)
[WINDOW_AVG] : Table (across)

4. Right click on [RANK] -> [Edit Filter]

Set Range of Values as 1 ~ 10

User-added image
Дополнительные ресурсы
Tips: Use WINDOW functions to deal with missing data when needed.
Номер статьи базы знаний

001456825

Вложения

top10.twbx

1307 KB

 
Загрузка
Salesforce Help | Article