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