cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sunnysaini9988 Frequent Visitor
Frequent Visitor

Show Total for a selected Dimension

Hi Experts,

 

I have report sourced from SAP HANA and I  need to show the Totals by a particular Dimesion .

 

Here I need to show Totals by Currency Dimension.

ExampleProductProduct GroupCurrencySales
 P1PG1USD1000
 P2PG2CAD2000
 P3PG3USD3000
 P4PG1CAD4000
 P5PG2CAD5000
 P6PG3USD6000
 P7PG1CAD7000
 P8PG2CAD8000
     
     
ExpectedProductCurrencyProduct GroupSales
 P1USDPG11000
 P3USDPG33000
 P6USDPG36000
  Total 10000
 P2CADPG22000
 P5CADPG25000
 P7CADPG17000
 P8CADPG28000
  Total 22000

 

 

Thanks

2 REPLIES 2
Super User
Super User

Re: Show Total for a selected Dimension

you can have the subtotals in the matrix if you use fork drill down, see here - would that work for you?
Capture.PNG

sunnysaini9988 Frequent Visitor
Frequent Visitor

Re: Show Total for a selected Dimension

Thank You Stachu. This helps.

However, i find drill down little bit cumbersome with Matrix. Wanted to have a flat view like in Table and show subtotals.

Is there a way to do that using Table visualization?

Thanks.