4 Replies Latest reply on Jun 19, 2018 11:47 PM by dmitry.beransky

    Calculating a total for the visible date range

    dmitry.beransky

      For my data I want to show a running total chart for a filtered date range.  To make sure the total line doesn't start at zero for the range, I used the trick of converting a date from a dimension to a measure ( LOOKUP(min([date]), 0) ).  Now, I also want to show two columns: the total for all of the data and the total for just the visible/filtered range.  I can do the overall total, but I can't figure out how to do the total for just the visible data.  Please see attached Superstore sample workbook.