Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

SUM by GROUP

Hello

 

I have this data:

 

A, 1

A, 2

A, 3

B, 4

 

I want to create a graph with the x axis to be A and B and the y axis to be the 1+2+3 for A and 4 for B (ie the sum of all the values under A).

 

Can you tell me how to do that please?

 

Thank you!

Need Help
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    Write a measure to sum your values

    Amount = SUM ( YourTable[Value] )

    Then pull the category (A, B, etc) into the x axis and the measure into the values  section.

1 Reply

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    6 years ago

    Write a measure to sum your values

    Amount = SUM ( YourTable[Value] )

    Then pull the category (A, B, etc) into the x axis and the measure into the values  section.