Is there any chance to get a sample mock up data in packaged workbook?
Not sure I totally follow - it would be easier if you included a twbx workbook thie the data - but you are using table calculations in your analysis - they are on the bottom of the order of operations (the last calculations made - even after totals) - so what does that mean - at that point only other table calculations are available (you can nest table calcs) - you could try window_sum() if you are still totalyying in your intervals or window_max() if yo are looking for the max
There may also be a way to avoid the table calculation in your original interval calculation using LOD's but I would need to see the data and viz
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.