power query/ dax measure , multiple conditions/ multiple answers

I'm not sure if you want a solution through formulas, but if so, then apply below formula.

=PIVOTBY(D2:D12, E2:E12, XLOOKUP(D2:D12, A2:A9, B2:B9) * F2:F12, SUM,, 0,, 1)

Hope this helps.

Power Query variant with Grand Total

let
    Source = Table.Join(Shares, {"employee"}, Revenue, {"category"}, JoinKind.LeftOuter),
    AddShared = Table.AddColumn(Source, "Shared", each [share accountmanager]*[revenue], Currency.Type),
    SelectColumns = Table.SelectColumns(AddShared,{"employee", "accountmanager", "Shared"}),
    PivotManagers = Table.Pivot( SelectColumns,
        List.Distinct(SelectColumns[accountmanager]), "accountmanager", "Shared", List.Sum),
    AddTotal = Table.AddColumn( PivotManagers,
        "Total",
        each List.Sum ( List.Skip( Record.FieldValues(_) ) ),
        Currency.Type),
    GrandTotal = Table.FromColumns(
        {{"Grand Total"}} &
        List.Transform( List.Skip( Table.ToColumns( AddTotal ) ),
            (q) => {List.Sum(q)} ), Table.ColumnNames(AddTotal)
    ),
    Result = AddTotal & GrandTotal,
    DeclareType = Table.TransformColumnTypes( Result,
        List.Zip({ {Table.ColumnNames( Result ){0}}, {type text} } ) &
        List.Transform( List.Skip( Table.ColumnNames( Result ) ), (q) => { q, Currency.Type } )
    )

in
    DeclareType

An alternative could be Power Query. In the attached file you can add data to the blue dynamic tables. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.

As variant you may add both tables to data model with relationship as

Add measure

Shared:=SUMX (
    Shares,
    Shares[share accountmanager]
        * RELATED ( Revenue[revenue] )
)

and build PivotTable from data model using above measure

Here is a formula approach if table are loaded to sheet.

=PIVOTBY(D2:D12,E2:E12,XLOOKUP(D2:D12,A2:A9,B2:B9)*F2:F12,SUM,0,0)