Forum Discussion

zamboni1199's avatar
zamboni1199
Helper II
5 years ago
Solved

Need help creating a subtotal

Hello,   I'm trying to create a subtotal for "Submitter" below, but not sure how to do it.  I'd like a subtotal row to be inserted after "Chris Hines" and it should say "3".  After Joy Lynne Burke ...
Need Help
  • FrankAT's avatar
    FrankAT
    5 years ago

    Hi zamboni1199 ,

    is this what you are expecting?

     

     

    # of appearence = CALCULATE(COUNTROWS('Table'),ALLEXCEPT('Table','Table'[Submitter]))

    With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
    FrankAT (Proud to be a Datanaut)

amitchandak's avatar
amitchandak
Super User
5 years ago

zamboni1199 , That you can get in matrix visual. You can selectively switch off the sub totals you do not need.

zamboni1199's avatar
zamboni1199
Helper II
5 years ago

Thank you.    I don't see where the subtotals are.  I am trying to count the number of instances a submitter appears (it is not a numeric value but is a text value).  I guess I'm looking for a "Count" rather than a subtotal.