If the calculation works when IDs and Total Spend are displayed, then you may need to hide the Total Spend column and use a filter to remove the extra rows.
Depending on how your calculation is set up; either of this calculated fields will work.
FIRST() == 0
Alternatively, LAST() == 0
Add the calculated field to the filter shelf and set to True. Since this is a table calculation, you will tell Tableau how to perform the calculation (Partitioning/addressing).
Hope this helps.
Thanks, I've tried something similar to this but the query time is above
20min. Is there another way to approach this without having an exhaustive
On Mon, Aug 13, 2018 at 2:34 AM Okechukwu Ossai <
The slow query time is probably due to the size of your data (several million rows) and the number/type of calculated fields in your workbook. My suggestion will be to move some of the calculations to your database if possible. You can also create different data sources with different levels of aggregation to answer specific questions instead of using a single large data source as one-stop shop for your analysis.