Display Data in Table/Matrix Table like a Group Right Table in Power BI

[pwc_ananta]

Hi
I am facing the issue to show the data in the following format. As I am required to show the details sum ignoring the TOD date and Destination.

Currently I am getting the data in all the rows, its not grouping. I have tried the Matrix table too but its group left the data. The current output of my table visual looks like the below image.

Any way around to display the data in the above shared form?

[amitchandak]

@pwc_ananta , I doubt you can have a table/matrix like the one you have shown in image 1.  Grouping is only possible for rows and columns, not for values

[pwc_ananta]

The image 1 is the output of Oracle XML Report. In which values are summed up on the basis of 5 columns. These duplication entries are occuring due to 2 drilled down columns that are delivery_date and dcpo(country). 

[v-jingzhang · Accepted solution]

Hi @pwc_ananta 

If you want to show a sum value in only one row, you could remove delivery_date and dcpo(country) columns from the table visual. Or provide proper aggregation types for both. Do not select "Don't summarize" for both. 

Best Regards,
Community Support Team _ Jing