If you hide an empty period in a table using a rule, it will still compare to the previous column. If you right-click > Hide, it will now ignore the missing data period. However, if the period is sometimes missing based on filtering only, it's not possible to ignore this period only when it's missing data while using this setting.