+ Start a Discussion

Advanced Reporting and Snapshots

I am trying to perform some advanced reporting in salesforce.com using the Analytics Snapshot feature.  Basicaly, I want to report on Opportunity Products by Stage over a two week period (Last Week vs This Week).  Currently, I am trying to use the Custom Summary Formulas (PARENTGROUPVAL and PREVGROUPVAL to calculate week-over-week comparisons WITHIN weeks.  I have constructed this model to help.

Snapshot Example
Unfortunately, these functions cannot calculate within sets, only between sets.  Does anyone have a solution to calculate these values to show like the above example?  Should I traanspose the data set or modify the data to figure this out?


Example is not visible. Please post it again.