I have a PBi report published. Within the report I've created a summarizedcolumns table that the user can Excel analyze (instead of hiding all the protected data columns).
Per Microsoft I have ensured the columns to be used as values are set with aggregation:
And yet when analyze in Excel get the "field you are moving cannot be placed in that area of the report"
Sooooooooooo, what am I missing or what else do I need to do?
PBi desktop is Version: 2.118.828.0 64-bit (June 2023)