Home

How to create a matrix formula which considers two conditions before performing calculus.

%3CLINGO-SUB%20id%3D%22lingo-sub-683365%22%20slang%3D%22en-US%22%3EHow%20to%20create%20a%20matrix%20formula%20which%20considers%20two%20conditions%20before%20performing%20calculus.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-683365%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20create%20a%20formula%20which%20helps%20me%20calculate%20a%20median%20with%20data%20that%20must%20belong%20to%20certain%20lines%20in%20which%20two%20categories%20appear.%20An%20example%20would%20be%20the%20following%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EColumn%20T%3A%20brand%20name%3CBR%20%2F%3EColumn%20AC%3A%20Time%20of%20the%20Year%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20idea%20would%20be%20to%20be%20able%20to%20calculate%20the%20median%20of%20all%20data%20which%20belong%20at%20the%20same%20time%20to%20T%20(Microsoft)%20and%20AC%20(Summer).%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20plan%20is%20to%20make%20two%20drop%20down%20lists%20which%20would%20serve%20as%20selectors%20in%20the%20final%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWere%20anyone%20to%20have%20any%20clue%20on%20how%20to%20do%20so%20I'd%20appreciate%20some%20help%20%3A)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-683365%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Deleted
Not applicable

Hi!

 

I am trying to create a formula which helps me calculate a median with data that must belong to certain lines in which two categories appear. An example would be the following:

 

Column T: brand name
Column AC: Time of the Year 

 

The idea would be to be able to calculate the median of all data which belong at the same time to T (Microsoft) and AC (Summer). 

 

My plan is to make two drop down lists which would serve as selectors in the final table.

 

Were anyone to have any clue on how to do so I'd appreciate some help :)

Related Conversations