Filter on a Dimension?

marisl2104

Hi together,
I´ve got a serious problem. I´m programming NAV for several years now, but I´ve never had such a problem. Hope you can help me?

In a Report, I´ve to set a Filter like:
SETFILTER("Sales Dimension Value",'%1',Salesperson);

BUT this "Sales Dimension Value" is a field with a TableRelation:
"Dimension Value".Code WHERE (Dimension Code=FIELD(Sales Dimension))

Thus, my filter doesn´t work.

Does anybody know, what I´ve to do?!

Thanx and regards,
Marisl2104

daryo

Didi you try using Global Dimension x Code (the exact name of the field as you see in the table designer)?

skulla

Your table relation for the field should be

"Dimension Value"."Dimension Code" not "Dimension Value"."Code"