Hi,
I want to compare sales in YE 2023 and 2024 for the smae month.
However, when I bring in Sales a second time to do Diff from Prev...I dont want to return a value if the comparitive month for current Year is blank.
E.g. future dates theres no comaparitive then dont return the diff. *There will only ever be current year and last year to compare.
Is this a setting? or is the only way around this as a calculated field, or creating the diff as a column in my source data?
Additionally if you have an entire column blank eg Diff for 2023 can this be hidden without hiding the whole column?
I want to compare sales in YE 2023 and 2024 for the smae month.
However, when I bring in Sales a second time to do Diff from Prev...I dont want to return a value if the comparitive month for current Year is blank.
E.g. future dates theres no comaparitive then dont return the diff. *There will only ever be current year and last year to compare.
Is this a setting? or is the only way around this as a calculated field, or creating the diff as a column in my source data?
Additionally if you have an entire column blank eg Diff for 2023 can this be hidden without hiding the whole column?