Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
you can untick "Include null values" for Date field.
I hope it helps.
Create a Rowno() sequence generated in script and use it on front end.
Or use Rowno() in front end to hide rows.
Thanks Andrea - but where do I do this?
Where do I do this Andrea?
under your dimension column, you'll find it below the label box.
can you send me a screen shot of where to do this - I am struggling!
here you go.
Great that works!
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