I have a problem with dashboard, Lifetime Sales and Revenue displays different figure.i have tried displayed lifetime sales by following code:
Mage::getResourceModel('reports/order_collection')->calculateSales()->load()->getFirstItem()->getLifetime();
and it is displaying correct, same amount as Lifetime Sales on dashboard.
so i am getting confused whether lifetime sales is wrong or /revenue is wrong.
Can any body help me???
I did it with: Go to System → Config → Sales → Sale → Dashboard And mark Use Aggregated Data (beta)="Yes"