function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
dxfilo@mac.comdxfilo@mac.com 

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?

Pradeep_NavatarPradeep_Navatar

Example is not visible. Please post it again.