Convert Y-Axis to Percentage

[#1]

I need help to convert Y-Axis to Percentage. In Dimention I have two Dimensions "Week_Ending", "TAT_Days" and One expression "Count(Order_Number)".  When I plot a  Bar Chart, I see the Y-Axis in numbers and want to convert to %. I have a list of data as mentioned below as well as the chart.

Week_Ending      TAT_Days     Order_Number

3/3/2013             On-Time           A1

3/3/2013             On-Time           A2

3/3/2013             Late                 A3

3/10/2013           Late                 B1

3/10/2013           On-Time           B2

3/17/2013           Late                 C1

..........

[hic · Accepted solution]

I assume that each week should sum to 100%? If so, you should use

     Count(Order_Number)/Count(total <Week_Ending> Order_Number)

Further, you should format the expression to "Integer" and check "Show In Percent" (Numbers tab)

HIC

[#3]

Million Thanks it worked....