How do I calculate Decile?

[#1]

Greetings

I have the following data. How do I calculate Decile 10%,20%,30%,40%..90%

DATA

10

20

30

40

50

60

70

80

90

100

15

25

35

45

55

65

75

85

95

Thank you

[#2]

hi Viswaranjan

Thanks. I did look at the link before.

In my case For Dimension, I have the following

=if(DATA <= fractile(TOTAL DATA, 0.1), 10,

if(DATA <= fractile(TOTAL DATA, 0.2), 9,

if(DATA <= fractile(TOTAL DATA, 0.3), 8,

if(DATA <= fractile(TOTAL DATA, 0.4), 7,

if(DATA <= fractile(TOTAL DATA, 0.5), 6,

if(DATA <= fractile(TOTAL DATA, 0.6), 5,

if(DATA <= fractile(TOTAL DATA, 0.7), 4,

if(DATA <= fractile(TOTAL DATA, 0.8), 3,

if(DATA <= fractile(TOTAL DATA, 0.9), 2, 1)))))))))

so what will be the expression?

I have used SUM(DATA) for expression, I got the following chart

If I calculate in Excel (note I have used the formula PERCENTILE.EXC(RANGE, K)

I got the folloing answer

So I am bit confused..