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?

[agigliotti]

you can untick "Include null values" for Date field.

I hope it helps.

[passionate]

Create a Rowno() sequence generated in script and use it on front end.

Or use Rowno() in front end to hide rows.

[ketanvaria]

Thanks Andrea - but where do I do this?

[ketanvaria]

Where do I do this Andrea?

[agigliotti]

under your dimension column, you'll find it below the label box.

[ketanvaria]

can you send me a screen shot of where to do this - I am struggling!

[agigliotti]

here you go.

[ketanvaria]

Great that works!

[ketanvaria]

OK now the dates are showing fine. The issue is that is still adding up the total column when I do a KPI. So in this case the KPI should say 30.5K but it say 61K as its also adding the total column from excel