2 Replies Latest reply on Jan 30, 2019 8:57 AM by Linda Dawson

    All amount when the data is bigger than selected date without using parameter

    Linda Dawson

      Hi,

       

      I have a simple data source:

       

      date,amount

      1/2/19,8

      1/3/19,9

      1/5/19,10

      1/6/19,11

       

      I want to make a simple worksheet with date in active filter, and I want to show the total amount which is bigger than selected date. For example, when I select 1/2/19, the amount shows 8+9+10+11=38, when I select 1/5/19, the amount is 10+11=21. If I select 1/6/19, then the amount is 11. I know it is easy to do with parameter. But here I don't want to use parameter, I only want to use date in the filter.

       

      Thanks,

       

      Linda