Hello Team!
I am new to the forum though i use to regularly get help from the posts as a guest. I am hoping a question of mine would be solved
I have a table with lot of data of opportunities in Pipeline from different departments in the organization, i want to get the Top 10 values based on the criteria i select for eg: Outcome-Win, Department-Healthcare (data validation drop downs), i have got a way to generate the Top Values using the below formula and it works well. The question here is I am not able to get the related fields attached to the value. The TotalValue is towards extreme right of the table and same sales value may be generated to different outcome or departments.
=SUMPRODUCT(LARGE((Table111[Department]=$B$6)*(Table111[Outcome]=$B$20)*(Table111[TotalValueOfSale]),1))
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I am new to the forum though i use to regularly get help from the posts as a guest. I am hoping a question of mine would be solved
I have a table with lot of data of opportunities in Pipeline from different departments in the organization, i want to get the Top 10 values based on the criteria i select for eg: Outcome-Win, Department-Healthcare (data validation drop downs), i have got a way to generate the Top Values using the below formula and it works well. The question here is I am not able to get the related fields attached to the value. The TotalValue is towards extreme right of the table and same sales value may be generated to different outcome or departments.
=SUMPRODUCT(LARGE((Table111[Department]=$B$6)*(Table111[Outcome]=$B$20)*(Table111[TotalValueOfSale]),1))
<colgroup><col><col><col><col><col><col><col></colgroup><tbody> </tbody> |
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>