Hi I saw many similar posts about using 'table calculations' to filter the view without the underlying data but I wasn't able to match my specific case.
In my case I am showing a metric for the last 20 days by date. I only want to show this metric if the total amount we spent that day is over a certain amount. I tried to do LOOKUP(sum(spend)). But this is NULL. Any idea how I would do this? Thanks.
Could you provide some sample data or a packaged workbook?