Information broadcasting: hide repeated values not working

i have the "hide repeated key values" checked in my BeX query.

but when i create a Information broadcasting setting on this query i see repeated values of the characteristics

Distribution type: Broadcast email.

output format: XML (MS excel)

i am getting an attachment in my SAP inbox