Bar chart to show an extra bar showing the sum of first three bars?
Hi All,
I have a new requirement in reports. I need to build a chart that shows the oppty pipeline revenue in 3 different buckets based on revenue amounts. I built a case statement using bins on the Revenue field. The bins are 10K-500K, 500K-2000K and >2000K, and made a pivoted chart off this. So the chart has 3 bars showing these three bins. So far so good. I was asked to add a fourth and bigger bar on the chart showing the sum of the first three bars. I tried adding another bin on the field with value as >10K, and
I have a new requirement in reports. I need to build a chart that shows the oppty pipeline revenue in 3 different buckets based on revenue amounts. I built a case statement using bins on the Revenue field. The bins are 10K-500K, 500K-2000K and >2000K, and made a pivoted chart off this. So the chart has 3 bars showing these three bins. So far so good. I was asked to add a fourth and bigger bar on the chart showing the sum of the first three bars. I tried adding another bin on the field with value as >10K, and
0