Hi Gianni, Thank you for your suggestion and solution.

Hi Gianni, Thanks for sharing...I have another challenge could you please help me on the same... I have date format which is MM/DD/YYYY format for example 5/31/2017 ...I need the output in the format of '31-May' could you please assist me on this....Thank you

I am still not sure on this formula...I am looking for example ..there are 1000 ID's against each ID there will be value and in these ID's there are lot of repetitive in nature hence, I should get the sum total for ID....if 10 same ID's then I should get the sum of all 10 ID's in all ten rows....in below table result…

Hi Luiz, I need one help here...in your given table, how to do the calculation in DV to get the column ID_ANSWERS_CLASS.?? Thank you