How to achieve the requirement

[kunkumnaveen]

Hello All,

I have a column called Bucket which has the value  as shown below

Bucket

1D

2D

2W

1W

1M

4M

2M

10Y

5Y

3Y

Dec.21

Dec.22

Dec.23

Jan.21

Jan.22

Jan.23

Mar.21

Mar.22

Mar.23

Jul.21

Jul.22

Jul.23

I am using the above dimension in a Pivot Table and I has to  sort Bucket values as per the below

Required Output is :

Bucket

1D

2D

1W

2W

1M

2M

4M

3Y

5Y

10Y

Jan.21

Mar.21

Jul.21

Dec.21

Jan.22

Mar.22

Jul.22

Dec.22

Jan.23

Mar.23

Jul.23

Dec.23

Kindly share your suggestion  in achieving the above requirement

Thanks 

[kunkumnaveen]

I have tried using below expression in Sorting 

Num(date#(Bucket,'MMM.YY')) 

but  from the above expression I am only able to sort Jan,Mar,Jun,Dec..but i need to sort D,W,M,Y also 

so what else should I have to include in the above expression