This repository has been archived by the owner on Oct 26, 2021. It is now read-only.
Conditional Percentile Calculation #5
WayneLambert
announced in
Excel Guides
Replies: 0 comments
# for free
to join this conversation on GitHub.
Already have an account?
# to comment
-
Formula shows the 50th percentile within the [NumericFieldForTable] data range based upon the conditions of the 3 dimensions being met. Notice the formula is an array formula.
{=IF(AND(SelectedValue1="WhateverText1",SelectedValue2="WhateverText2"), PERCENTILE(IF($A1=tblTableName[FieldNameForA1DataRange], IF(tblTableName[FieldName1]="WhateverText1", IF(tblTableName[FieldName2]="WhateverText2",tblTableName[NumericFieldForTable])),50))}Beta Was this translation helpful? Give feedback.
All reactions