Skip to main content

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.

 

Calculated field wrapped in ZN() throws off Column Grand Totals

3 answers
  1. Jan 18, 2017, 8:35 PM

    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.

0/9000