Delete row from table

[ketanvaria]

I have a table here (with sample  data) where the last two is just a sum of the all the months. I don't want to see this in the sheets and analysis. I know how to hid a column from analysis but how do you hide a row from analysis?

[ketanvaria]

[ketanvaria]

see my further point below - for A KPI

[achakilam1022]

May be

sum({<Date-={}>}ConsultancyIncome(2))

[nsetty]

Try excluding the records while loading itself.

[Sheet1]:
LOAD
Date([Date] ) AS [Date],
[Income],
[Consultancy Income (2)],
[Product Income (3)],
[Interest earned]
 FROM [lib://qlikid_ketanvaria/cross_Table_Sample.xlsx]
(ooxml, embedded labels, table is Sheet1)

WHERE Len(Date)<>0;

Add

WHERE Len(Date)<>0;

[agigliotti]

you can use the expression below:

SUM( {< Date = {"*"} >} [Consultancy Income (2)] )

I hope it helps.

[agigliotti]

Please mark the answers as Helpful / Correct if applicable to help others cummunity members.

Thanks.