Forum Discussion

Promethes_2's avatar
Promethes_2
Helper II
9 years ago
Solved

Matrix Total Question

Hello,   I'm trying to display just the column total in a matrix by a specifc field and can't quite figure out what I need to do diffferently.  Here is what I'm after.  Under each red line I want t...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    9 years ago

    Promethes_2,

     

    Instead, you could try to add a calculated column.

    transDate           operation =
FORMAT ( Table1[transDate], "MM/dd/yyyy" ) & REPT ( " ", 10 )
    & Table1[operation]
GilbertQ's avatar
GilbertQ
Super User
9 years ago
What if you simply remove the Operation from the columns? Would that then not give you the total per date, per card number?