Either any way..Help on Pivot and Slicer..

[VBABEGINER]

As said, either any way guide me guys..

Hello All,
I'm stucked in one problem..I have large excel data, based on which I created pivot and then using slicer, i finished that activity.

Now problem arise on,
in Row Label = I have Hour Number's..
in Value = I have take "Service request" count..

based on this, slicer are there to check variation in graph.

problem is,
user want to see, percentage on other one more axis..this percentage is the flow how request gets solve in hourly basis and reach finally to 100% task. (this is some thing known as "cumulative%")

I'm stucking in, if I place this formula outside of pivot table..

In C4
=B4/B33
In C5
=B5/B33
.
.
.

b4 = 00.00 hour value in pivot and b33 is Grand Total of pivot.
b5 = 01.00 hour value in pivot
b6 = 02.00 hour value in pivot
...so on till 23.00

another formula

in D4
=C4

in D5
=D4+C5

in D6
=D5+C6

Now my question is, when im using slicer..all formula goes wrong that is one and this is not capturing in graph..
How do i solve this..

 

[VBABEGINER]

Just add one point on this, I just got this..When I'm right clicking on pivot, "Show Value As" - "%Running Total In"..
This is what I want in 2nd graph..

Can I see this both on single graph..i.e. "Count which currently I have" and "%Running Total In" (Numbers and % both)..

 

[VBABEGINER]

Sorry to disturb you guys, I got the solution.
I just add one more count in "Value" field, and change them as, in %.
Cheerss..!!