Board 8 > Excel Question

(+) Yeah! (+)

I feel like this should be easy, but I can't figure it out.

I have a Pivot Table that I am using to summarize a bunch of survey questions and then have a slicer to limit based off the segment of the population the individuals are in.

I know I can show the values in the Pivot Table as a count or as a percentage of the total.

I want to show them as both.

So instead of showing 18 or 4.4% I want the column to show 18 (4.4%).

Is this possible?
---

Add the column to the values section of the pivot a second time. The values won't be in the same cell, but you can put a formula off to the side to concatenate the values.
---

I figured there was an easy way that I was just blanking on. Thank you.
---

Okay, follow up question. When I concatenate it loses the formating of the percentage so it is displaying as:

18 (0.0440097799511002)

Formula I used to concatenate:
=E21&" ("&F21&")"

Is there a better formula to use to keep the percentage formatting?
---

=E21&" ("&text(F21,"0.0%")&")"
---

Instead if F21 I'd put TEXT(F21,"0.0%") (or more zeroes after decimal if you want more points. It may also be #.#% instead, I forget which to use in which case but there is a subtle difference behind the two.

That'll force in the format in a concatenate situation (where you're already put of the number realm and into text anyhow)

TEXT function is highly versatile at making numbers appear as you want them to, including specific date formats...

steiner'd

but yeah, TEXT rules
---

You guys are awesome. Thank you.
---

Now I'm just grumbling that I have to rebuild every graph that I had made to show both values since I can't just change the data source since I'm going from a PivotTable to a table outside of the PivotTable.

For a very minimal change.

But the VP wanted it so I have to do it.

Grumble grumble.
---

Text function is a real MVP
---