I've got a YoY visual going here and I had to wrap my calculation in ZN() because some of the services that we have we didn't offer last year and I wanted to be able to color against an increase or decrease in $$$ and you can't do that with NULLs. But when I wrapped that calculated field all of a sudden the grand totals look like this....help.please.
3 answers
Kyle,
Without seeing the workbook — *cough* — I'm going to guess that you have a dimension on your Marks shelf (e.g. as a Detail). That's the #1 cause for multiple, overlapping labels.