I have this Report, of standard report type "Opportunities". I have added a cross filter "Opportunities with Products"
But I'm unable to find the standard field "Product Code" to be used in Sub-filter.
Is it a Salesforce limitation? I was unable to find any link/document from salesforce saying that. Any help will be much appreciated.
asked Jan 19, 2017 at 22:09
Add a comment
|
2 Answers
This is indeed a known limitation. The good thing though is that it's an idea 'Under Point Threshold' so you should vote for it so it gets included on the roadmap.
Unfortunately, there's no known workaround suggested either so you might need to pull the required data via custom Apex controllers.
answered Jan 21, 2017 at 7:24
After a bit of thought I got a work-around, which is an extremely easy one. I have created a formula field, which pulls the data of the Product code field. Being a custom field, you can show that field in the reports. Although it takes up an extra field, but at least, user will get what they want.
answered Nov 7, 2017 at 17:20