I'm not sure what's you've got there, but this is what I have done for a
project recently.
PT data is in A3:B12; numbers are in B5:B11 (I'm not including the Grand
Total in B12).

In C5:C11, put 1, 10, 20, 30, 40 50, 60.

In D5, copy/paste this function:
=FREQUENCY($B$5:$B$11,C5:C11)

Click on D5, and select down to D11 (not a fill-down).

With that range selected, click back in the formula bar, and hit ctrl +
shift + enter...all at the same time.

Than you can build fancy little charts and all kinds of fun stuff.

Does that help?


Regards,
Ryan---

--
RyGuy


"Roger Halbheer" wrote:

Hi All,
I am using Pivot tables on top of an Access DB. What I would like to do is a
calculated column using something like the RANK function wihtin the Pivot.
I have not found a way using this. Is this possible?
Thank you
Roger