Group by greyed out in Analyze in excel

[Jason6]

In the analyze in excel file downloaded from Power BI dashboard, the group button is greyed out in the pivot. Is there any means to enable Group by in pivot of analyze in excel

I tested this with date field, text feild , numeric field and all these have group greyed out

I can confirm that there are no blanks in the column ( calculated column)

[Fowmy]

@Jason6 

Grouping is not allowed on Analyse In Excel connection, you need to do the grouping in the Power BI model, you can add a calculated column with the required grouping logic.