3 Replies Latest reply on Jan 8, 2019 12:51 AM by Shashank Kumar

# Start Running Total from previous filtered out value

I have a running sum measure plotted across order date. If I filter out the date start value, the running sum loses the filtered out values. Is there any way we can keep filtered out running sum value while filtering the order date

• ###### 1. Re: Start Running Total from previous filtered out value

You have to use the Table Calculation filter instead of Normal Dimension Filter.

MONTH(LOOKUP(MIN([Order Date]),0))

Change Month to Year, Quarter as required.

• ###### 2. Re: Start Running Total from previous filtered out value

Hi Shashank Kumar,

These is because the table calculation is the penult one being calculated.

And it's based on the canvas. If you filter data, the canvas change, so does the table calculation.

Check out this link :Tableau's Order of Operations - Tableau .

If you can share a workbook or screenshoot i can provide exact formula for you.

YT

• ###### 3. Re: Start Running Total from previous filtered out value

Hello,

Thanks for the explanation. The above formula works.