I think this has come up a few time before, but I have't found an answer so I though I'd try bringing this back up. Is it possible to constrain "Prev Group Val" values to within a grouping?
I am trying to compare performance of my vendors week over week - so I have crated a Matrix report group by custom object "Vendor__c". I then have a sub group by Current_Week_c.
If Vendor "Acme" cost me $10,000 last week and $11,000 this week I would like to report that my spend was up 10% week over week.
This works perfectly for the first vedor, but falls apart for all subsequent vendors on the report as it pulls in "Prev Group Val" data from outside the Vendor__c group. Is there a way that I can keep this data within the grouping?
I have posted a picture of my output below, and also here is my formula-field-formula:
(TL_Client__c.Buyer_Spend__c:SUM / PREVGROUPVAL(TL_Client__c.Buyer_Spend__c:SUM, TL_Client__c.CurrentWeek__c)) -1
답변 2개
Hi John,
I am not sure if thats possible, other alternative is changing the report format to Matrix and have the CurrentWeek as Colum Grouping, Vendor in Row Grouping and the report output will be as below
