Hiding details in pivot tables but still showing rollup

[JamesCanale]

Here is a sample of my data (the mr.excel clipper got cranky with the pivot table for some reason). Column D is a calculated field (based on the employee status). I'd love to hide the detail in red, but show the overall in green. Can that be done? Showing the 0% or 100% isn't very interesting - but the total is interesting.

MrExcelPlayground.xlsx
	A	B	C	D
1	Row Labels	Hours	Dollars	Rate
2	Project 1	66.8	$ 9,452.52	72.3%
3	Phase 1	66.8	$ 9,452.52	72.3%
4	Employee 1	5.5	$ 778.86	100.0%
5	Employee 2	4.5	$ 637.26	0.0%
6	Employee 3	18.3	$ 2,584.41	100.0%
7	Employee 4	6.5	$ 920.46	100.0%
8	Employee 5	4.8	$ 672.66	100.0%
9	Employee 6	13.0	$ 1,840.93	100.0%
10	Employee 7	0.3	$ 35.40	100.0%
11	Employee 8	14.0	$ 1,982.54	0.0%
12	Project 2	216.3	$ 30,635.04	91.2%
13	Phase 11	216.3	$ 30,635.04	91.2%
14	Employee 2	8.5	$ 1,203.71	0.0%
15	Employee 1	43.3	$ 6,124.65	100.0%
16	Employee 3	10.0	$ 1,416.11	100.0%
17	Employee 4	48.5	$ 6,868.09	100.0%
18	Employee 5	1.0	$ 141.61	100.0%
19	Employee 6	1.5	$ 212.42	100.0%
20	Employee 7	15.6	$ 2,206.75	100.0%
21	Employee 11	11.3	$ 1,593.11	100.0%
22	Employee 9	48.3	$ 6,832.70	100.0%
23	Employee 10	4.0	$ 566.44	100.0%
24	Employee 8	10.5	$ 1,486.91	0.0%
25	Employee 12	8.0	$ 1,132.88	100.0%
26	Employee 13	6.0	$ 849.66	100.0%
Sheet13

 

[GlennUK]

Are those groups hierarchical? Like, Project, then Phase, then Employee? It'd be much easier to see a screen-shot and not just cell copies.