1 of 1 people found this helpful
I'm not completely sure I understand what you want. Here's one idea, using Measure Values to show the pyramid, then an additional 0 measure on a dual axis. The label for that 0 measure goes in the middle of the bars.
Hi Jon, We are certainly on the right track. I would like to show a value where you have the names across the bars i.e. "1,800" where you have "Technology" straddling the blue and green bars. For example, the pop pyramid for Technology bar is going to read "1800" which is made up of the 900 to the left and 900 to the right. The value I would like to show up the middle is a calc. field I can grab from the measures. I could not get the dual axis to work. Could you please walk me through. I really appreciate your help.
To get the desired label, create a calculated field that adds the two measures together. Then, place it on the Text shelf, in place on the Category field.
For the dual axis, do the following (assuming you already have a view with Measure Values on Columns like I described):
- As Tracy outlined, create a calculated field that will return the value you want to show for the combined bars.
- Create a measure (I called it 0) with just a value of 0.
- Drag that measure onto the Columns shelf. Now you get two charts, one that's your original and the SUM(0).
- Click on the green SUM(0) pill on the Columns shelf and choose Dual Axis from the context menu. Now you have one axis.
- Click again on the pill to set the Mark Type to Text.
- On the Marks card (which has SUM(0) as a heading), drag the calculated field you created in the first step onto the Text shelf.