View the original community article here
Last tested: Apr 23, 2019
Since totals require an extra sql query, the query is different then when totals are off and so explores with totals have a different cache then explores without totals. So it could be that results are pulling from two different caches. Try "clear cache and refresh" on both the non-totals explore and the totals explore.