Forum Discussion

razieh1990's avatar
razieh1990
Icon for Helper I rankHelper I
2 years ago
Solved

total value be shown only

Hello I created a matrix whose column is cities (A, B, C,) and the rows are the list of stations ( AA, BB, CC), and the value is the sale amount per city and station. I want to add another value: t...
  • tamerj1's avatar
    tamerj1
    2 years ago

    Hi razieh1990 
    You may utilize the "Total" to display the quantity 

razieh1990's avatar
razieh1990
Icon for Helper I rankHelper I
2 years ago

Hello tamerj1 

Thanks for your solution.

Is it possible to modify the solution you provided and calculate not only sum(sale quantity) but also sum ( sale amount) when it is not in the scope of city as total? 

I mean now we have one column as total quantity at the end of matrix but I want to add total amount as well. 

Do you think it is possible? 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
2 years ago

razieh1990 
You need to look into the table transformation detials inside the Power Query editor in the attached sample file.

  • razieh1990's avatar
    razieh1990
    Icon for Helper I rankHelper I
    2 years ago

    Thank you very much