CrossTab Percentile

[cubdh23]

Hi, I am trying to do this all day and i cant seem to make it work.
I have used this

IIf([qryCrossTab.Days]<1,"Day 1",IIf([qryCrossTab.Days]<2,"Day 2",IIf([qryCrossTab.Days]<5,"Day 5")))

In the field box where i use Column heading. My result produces a row such as this. Day 1 = 5 Day 2 = 3, Day 5 = 2 Total = 10

Now i would like for it to give a percentile. I would like the result to look like this.

Day 1 = 50%, Day 2 = 80%, Day 5 = 100% Total = 10

I would like Day 2 to add the values of the 2 days and day 5 to add the values of day 1, day 2 and day 5.

Any idea how to have a percentile result such as this? in a crosstab?

Thanks

 

[cubdh23]

Ok nevermind. I have solved the problem.
The problem was that i was using a Crosstab query to Group By my Cities.
When using Crosstab, you are limited by what else you can do.

I used a simple regular select query with group by and i got my percentiles.