sum(Total) on a top in a table

[LeaRupnik]

Hello,

I am interested in whether it is possible to show the sum (total) at the top and not at the bottom in a matrix table or an ordinary table.

Thanks,

Lea

[Anonymous · Accepted solution]

Hi @LeaRupnik,

As Greg_Deckler said, current you can directly use the default features to achieve your requirement in table visual.

In my opinion, I'd like to suggest you create a calculated table to append 'total' row to your table with summarizing results and create a custom table to setting custom sort.

Custom Sorting in Power BI 

Regards,

Xiaoxin Sheng

[Greg_Deckler]

@LeaRupnik No. You would have to use a matrix visual with a hierarchy with "surface" the total.

[amitchandak]

@LeaRupnik , Option it as sub total Level.  When there is sub total you can show even grand total at the top. I doubt any option for grand total like that