format issue

[soniasweety]

Hi all

I have a dimension like below

=aggr(if(Hour12<>'NA',Hour12),Hour12)   

here hour132 values having   01,02,03,04     like that

so my dimension values showing  01,02,03     but I want the result like

11:00 AM    12:00 PM    01:00 PM   like  that   how can I achieve this?

[soniasweety]

thanks sasi its working fine