1 Reply Latest reply on Oct 30, 2018 9:11 AM by Ken Flerlage

    How can I filter the view without underlying data using sum?

    kevin.mardakhayev

      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.