Show blank if value is the same as the previous value

Anonymous — Tue, 03 Nov 2020 10:09:37 GMT

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.

Re: Show blank if value is the same as the previous value

amitchandak — Tue, 03 Nov 2020 11:06:46 GMT

Anonymous , not very clear. But you need formual like

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