Remove empty lines from table

[#1]

Hi all,

Perhaps a simple question, but I'm having trouble figuring it out. I need to remove the Null values from a table (see attachment), but the first row should always be displayed! So 'don't show if value is empty' does not work here, since it will also not show the first row?

Thanks,

Stijn

[#2]

Well the first row always has the lowest km_val value (for that certain MRCE number). Perhaps this can be used?

[#3]

Perhaps it is easier to delete the duplicate km_val in table2? see attachment

[#4]

I need the first row because it shows the beginning km_val for that MRCE value. And it has no previous date, so the first row should display -, while the other rows should only show the date and not a -

[#5]

Is anyone having an(other) idea?

[CELAMBARASAN]

You could try something like this

If(RowNo()=1, [MRCE Nr.], Only({<[Prev wo_date]={'*'}>}[MRCE Nr.]))

or this one

Only({<wo_date={'$(=Min(wo_date))'}>+<[Prev wo_date]={'*'}>}[MRCE Nr.])

[senpradip007]

PFA

[Anonymous]

Try this:

load the data from the excel sheet

load with noconcatenate from resident with rowno()

and order by km_val

load

rowno(),

if (rowno()=1, km_val) as StartKMVAL

...

...

resident PrevTable

order by km_val

Then you should be able to define

if (StartKMVA), "Start KM", wo_date)

and the first row should be displayed