Forum Discussion

jacobmiller2322's avatar
jacobmiller2322
Frequent Visitor
3 years ago
Solved

Sum values with a certain group excluded

Hi,

 

I am trying to do a project and am running into an issue.

 

I am attempting to take the sum of a column, but want to only take the sum of the rows that are under a certain grouping of 22 I have made.

 

Normally I would be fine, but I have 22 groupings and want to take the sum of $ for 21/22 of them.

 

Here is an example:

Group  $ Amt

Parts  $75 

Parts   $65

Raw  $55

FG  $75

Rent  $85

Rent  $15

In this example I would like to find out how to sum the $ with everything besides the raw group. 

 

So basically how would I write a measure that would return $315 in this example