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.
|Metric||Clients:||Clients: New||Clients: Existing||Patients:||Patient||Patient||Patient||Visits: 1||Visits:||Visits:||Visits:|
|Director # Current Period||400||400||400||400||400||400||400||400||400||400||400|
|Director # Previous||400||400||400||400||400||400||400||400||400||400||400|
|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%|
Depending on the desired output, which I understand to be just the results of the % difference, the best option may be to put the table calculation on a worksheet of its own and hide the unwanted columns. Then, place the two worksheets side by side on a dashboard.
Hope that helps!