I added a grand total row to a "Count" in SQL, which I needed for some counter visualisations. I used the "ROLL UP" command to get the grand total.
However, I have a pie chart which references the same count, and so the grand total row has been added as a slice on the pie chart (obviously 50% of the pie)
There is no obvious way in the "Edit Visualisation" section to filter out rows.
I can click on the relevant legend, which filters the slice out of the pie chart. However the legend itself is still showing on the visualisation, which I don't want. (see underneath red arrow on attached image)
Any ideas how I would get rid of it from this visualization?
I have tried adding filters at Query level, but that also removed the grand total from the counters!
Thanks
