I have the following formula:
SUM(SUMIFS(SD[Gross Amt],SD[FY],[@FY],SD[Period],AY$1,SD[Employee ID],[@[Emp ID]],SD[Title Code],{[@[Ttl Chg]],[@[Title Code]]}))
The part in bold is what I need help with. Typically, you would use the braces for multiple criteria in the same column, however I'm not sure how to adapt this for criteria from a table. Is this even possible? I appreciate any help. Thanks.
SUM(SUMIFS(SD[Gross Amt],SD[FY],[@FY],SD[Period],AY$1,SD[Employee ID],[@[Emp ID]],SD[Title Code],{[@[Ttl Chg]],[@[Title Code]]}))
The part in bold is what I need help with. Typically, you would use the braces for multiple criteria in the same column, however I'm not sure how to adapt this for criteria from a table. Is this even possible? I appreciate any help. Thanks.