1 Reply Latest reply on Jul 1, 2013 12:28 AM by Tracy Rodgers

    Trying to format a cross tab view with table calcs below totals

    Rob Strong

      Anyone have a solution for this. I know there must be one out there. The table consists of blended data from 3 different sources and when I try to run a table calc to get the % difference it adds as a column. I can't attach the work book or worksheet because of proprietary data. Looks like it should be simple but I've been bashing my head against it the whole afternoon. Any suggestions are welcome and very much appreciated.

       

      Thanks

      Rob Strong

       

       

      Metric Clients:Clients: New Clients: Existing Patients:Patient Patient Patient Visits: 1Visits:Visits:Visits:
      Total Total122234
      Director # Current Period400400400400400400400400400400400
      Director # Previous  400400400400400400400400400400400
      Director % Change - #0%0%0%0%0%0%0%0%0%0%0%
      Company % Change - #5%5%5%5%5%5%5%5%5%5%5%