Thanks @ColemenWilson I'll give that a try :)

Hi @ColemenWilson I need to create the formula in the ETL as I have to include it in other calculations in my output dataset I tried the below but that didn't return any values and there are definitely values for last year CAST( CASE WHEN YEAR(`Month`) = YEAR(CURDATE()) -1 AND MONTH(`Month`) = MONTH(CURDATE()) -1 THEN…

This might be the most in depth and detailed response I've ever received to a challenge before! Thank you so much.. When I am back on this project, I will be implementing this solution!

Aye, I'm pretty sure as I'm saying in the calculation above ( Hierarchy = 'Revenue') and then filtering out the respective line item, I end up with the problem you've mentioned Sadly, I'm only a few months into using Domo so I haven't discovered a solution to the aforementioned problem :(

Thank you @ColemenWilson - I'm currently undergoing a 'trial by fire which is on fire' and I'm still getting used to all the functions within Domo 😊