You need to sign in to do that
Don't have an account?
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.
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.