Create a grouped column when in live connection

[imarkopoulos]

I have a report report from a live connection to analysis services.

My report is a simple table like the following

category Measure
A 1
BB 4
B 4
C 2
D 3

I Want to show the category in the following Grouped form
category Measure
A 1
B 8
C 2
D 3

This would be easy when connected to an excel/csv file i would just create a calculated column.
How could i do that since when connected to a live connection i can only create calculated measures?

Can i somehow group the categories?

[Anonymous]

Hi Greg_Deckler ,thanks for the quick reply, I'll add more.

Hi @imarkopoulos  ,

Did you mean to enter 'B' here? If yes, you just need to create the visual object as shown below.

If not, as Greg_Deckler  said, switch 'Live connection' to 'Direct query' here.

Best Regards,
Wenbin Zhou

[Greg_Deckler]

@imarkopoulos Switch to DirectQuery and add a local model?