I have recently started exploring with Analysis for Office. I am using version 184.108.40.2068.
On selection of perticular bex queries as data source for analysis I get results for some sets of rows and combination.
Now my problem is I am not able to remove objects (measures) from columns section in Design Panel (cannot drag and remove or right click removed is greyed out) but I can remove all objects from rows.
To my surprise I am observing this behavior only with few bex queries for others I can add or remove objects from rows and columns. Being beginner I am quite unsure about the aspects I need to look into.
I could not track similar scenarios in a forum.
I would appreciate any guidance regarding the same.