Show blank if value is the same as the previous value

[Anonymous]

Hi,

I have got a month-to-date sales table looking like:

...

The "MTD Salg" just replicates the first/previous value in the rest of the table if no value exists within the specific date.

I want the table to show blanks instead of just showing the previous/first value - is this possible?

I hope  you can help.

[amitchandak]

@Anonymous , not very clear. But you need formual like

if(isblank(sum(Table[sales])), blank(),[MTD Salg])