Can anyone please tell me the tables and calculations used to generate this graph. Client has been using it for a few years but a few weeks ago it went nuts. I am trying to trouble shoot the cause but not having any luck. Sales Reports - Analysis and History that show Profit % and dollars look normal.
Nasha, I suggest you to use Profile Scripts and Sql server profiler while running the KPI. By using them you may get the table details.
The answer to this question is GL Categories - it is not directly tables. I opened a ticket with Microsoft and as soon as he mentioned categories it was simple to see the problem.