Forum Discussion

pwc_ananta's avatar
pwc_ananta
Icon for Helper I rankHelper I
4 years ago
Solved

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

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...
General Comment
Interesting Links
Need Help
Tips and Tricks
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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's avatar
pwc_ananta
Icon for Helper I rankHelper I
4 years ago

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's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    4 years ago

    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