You need to sign in to do that
Don't have an account?
devindiaa
Scenario: There is a multi select field with 10 values. I created 10 different fields, populating with either 1 or 0 depending on whether that value is selected or not. Then created a report and summarized all these 10 fields getting a grand total. I want a percentage of these values in entire object via pie chart/ combination chart or Is there any other way of doing it?
pie chart wedges for fields in object
Scenario: There is a multi select field with 10 values. I created 10 different fields, populating with either 1 or 0 depending on whether that value is selected or not. Then created a report and summarized all these 10 fields getting a grand total. I want a percentage of these values in entire object via pie chart/ combination chart or Is there any other way of doing it?
Have you tried adding a formula to the report for this purpose? For details on addning formula in report please refer following help document:
https://help.salesforce.com/HTViewHelpDoc?id=reports_builder_fields_formulas.htm&language=en_US
There is an alternate way by creating formula fields as defined in the KB article below:
https://help.salesforce.com/apex/HTViewSolution?urlname=Multi-picklist-and-reporting-1327108663833&language=en_US
Please go through..
Vinita- The formula limit is 5, I need 10 wedges in pie chart.
Sonam- I already created formulas for multi-picklist, do not want to work with excel.