Forum Discussion

imarkopoulos's avatar
imarkopoulos
New Member
1 year ago

Create a grouped column when in live connection

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?

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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