Foreign Calendar Date Grouping in Pivot table

[Pmmah]

I used custom format ([$-1970000]B2dd mmmm yyyy;@) to be able to enter the date value in Hijri Calendar, but when i use pivot table and try to group according to date, i found the date grouping is based on Gregorian Calendar.

​

My question is; possibility of grouping date based on Hijri calendar and use all features of pivot tables according to that (Timeline, , ... etc.)

Even if i use only Hijri format ([$-1170401]B2dd mmmm yyyy;@) i face the same problem

Please find the below link for sample file

Sample For Foreign Calendar.xlsx - Google Drive
(Kindly open in Excel format not google sheets)

Thanks
Mahmoud