2 Replies Latest reply on Oct 24, 2016 10:47 AM by Josh Delekta

# Calculation Using Multiple Filters

Is there a calculation to pull information from two different columns but not double count? I put together an example workbook of what I need to accomplish and attached here.

The total in the data is \$2,785,000

If you filter on BU1 the total is \$550,000

If you filter on OE1 the total is \$585,000

If you filter on BU1 and OE1 the total is \$200,000

The total should be everything that hits BU1 and OE1. However, I don’t want to double count the amounts that hit both BU1 and OE1.

The total I am expecting from the attached example is \$935,000.

It would include Supplier 1, 2, 3, 4, 5, 8 and 10. It would not double count Supplier 4 and 5 because they happen to include both BU1 and OE1.

Thoughts? Thank you. I appreciate it.

• ###### 1. Re: Calculation Using Multiple Filters

Hi Josh,

Using the sum of the below calculation, I was able to get the \$935,000 value:

if [Business Unit]="BU1" or [Cost Center]="OE1" then [Spend] else null end

Hope this helps!

1 of 1 people found this helpful
• ###### 2. Re: Calculation Using Multiple Filters

Kathyrn,

This worked! Thank you for your help. Thank you everyone else as well. I appreciate it.