Pivot Table in Hijri Dates

[FaizanKhan82]

Hello every one !

I have converted normal dates to Hijri dates but I am unable to group these Hijri dates in Pivot table to see month wise sales. Need your help.

Regards,
FKhan.

[Glenn Kennedy]

See here:

https://answers.microsoft.com/en-us/...1-a3c9ba04a354

It looks like there was a solution to this, but it no longer works with Excel 2016... Isn't progress wonderful.

[FaizanKhan82]

Thx for ur reply, but this does not work, when we insert pivot table these hijri dates are not appearing as group like month and year but it only appears as date.

[Glenn Kennedy]

If you read the article... it says it no longer works for Excel 2016 and later. You have Excel 2016, so it won't work

[FaizanKhan82]

It is not working in other excel version too. I need grouping of hijri dates in Pivot to see Hijri month wise Sales like in Total Sales in Moharram 2000 tons....
If any body can do this pls show the results....
Thanks,