TAR01 Detailed Sales Target module L3

omarismailcch1

Hi All my question is related to

TAR01 Detailed Sales Targets — PY Country and Product Family Sales Line item

I’m stuck and need some help. I came across posts suggesting to use SUM first and then LOOKUP, but I’m not fully understanding the logic behind it. I’ve attached the formula I used in the PY Country and Product Family Sales line item, but it’s returning incorrect numbers. Could you provide some hints or explain the logic? Thank you!

Screenshot 2025-12-21 203725.png

Kanishq17

Hello ,

Can you share a snip of the FPA forecast line item , basically it stands for PY revenue offset to current year which is pulled from hub but that is at account and product level , so get that by G2 country and P1 product family (sum based on country mapping in account)