This is tough to explain but hopefully I can keep it simple. I am also wondering if I need to do this at the data level. I have a E&O Value that is constant across my data. However there are missing values if there is no quantity received for that canumber for that quarter. For example in the data set below - E&O for 17129 is 27 as you can see in Q4. In Q1 there is no quantity received so I am not seeing the E&O value for 17129 so my total is not accurate. Is this a data issue that I need to fix at the data level or is there a clever way to do this in Tableau. I am attached the workbook in case there is a way to do this in Tableau.