I am trying to Connect G/L Entry with the Dimension Set Entry table so that user can filter combination of dimensions .
I tried linking the table with multiple combination
LINK="Dimension Set Entry"
Dimension Set ID =Dimension SET ID
Dimension Code="Dimension1"
Dimension Value Code =*
It is working fine but if I have to filter more than 1 dimension and since only 10 filters can be used so iam trying to use special FILTER= Command. When iam running it , it is not showing any error but showing the total value without applying any filter.
=NL("SUM","G/L ENTRY","Amount","G/L Account No.",E9,"Link=","Dimension Set Entry","Dimension Set ID","=Dimension Set ID","Filters=",Options!F5:G10)
EXCEL Range Cell values
F5-Dimension Code
G5- BRAND
F6-Dimension Value Code
G6-OCBAO1
F7-Link=
G7-Dimension Set Entry
F8-Dimension Set ID
G8-Dimension Set ID
F9-Dimension Code
G9-COUNTRY
F10-Dimension Value Code
G10-AU
