How to use Filters from another InLine file

[Anonymous]

Hi All

Is there any way to use filters from InLine parameter file like table below?

I have one fact file and fetching Amount for below output. If few lines than I can simply write condition for each lines. But I have more than 200 lines in report. Output is exactly like below. I need to match PSheetID and PLnNo to the fact table and getting last column Balance(not listed in below)

Reading as

If PLnNo='UCX1', sum({<SHEET_ID=pSheetID, LINE_NUMBER ={'6','20'} Sales)-sum({<SHEET_ID=pSheetID, LINE_NUMBER ={'13','23'}>} Sales)

If PLnNo='UCX2', sum({<SHEET_ID=pSheetID, LINE_NUMBER ={'13','23'}>} Sales)

ELSE sum({<SHEET_ID=pSheetID, LINE_NUMBER =pLnNo Sales)

This is not complete syntax but idea.

Point is how to use FILTERS from InLine file please

Thanks

PSheetID	Req	PLnNo	Section	Head	LnNm
A.1.b	N	1	ASSETS	Securities	Held to Maturity (HTM)
A.1.b	N	2	ASSETS	Securities	Available for Sale (AFS)
A.1.b	6+20-13-23	UCX1	ASSETS	Total Loans and Leases (Fair Value / LHFS & Amortized Cost)	Real Estate Loans (ex CRE Loans)
A.1.b	13+23	UCX2	ASSETS	Total Loans and Leases (Fair Value / LHFS & Amortized Cost)	CRE Loans
A.1.A	N	30	ASSETS	Total Loans and Leases (Fair Value / LHFS & Amortized Cost)	C&I Loans
A.1.b	N	35	ASSETS	Total Loans and Leases (Fair Value / LHFS & Amortized Cost)	Credit Cards
A.9.b	N	38	ASSETS	Total Loans and Leases (Fair Value / LHFS & Amortized Cost)	Other Consumer
A.1.b	N	43	ASSETS	Total Loans and Leases (Fair Value / LHFS & Amortized Cost)	Other Loans and Leases
A.9.z	N	109	ASSETS	Total Loans and Leases (Fair Value / LHFS & Amortized Cost)	Unearned Income on Loans
A.1.b	N	110	ASSETS	Total Loans and Leases (Fair Value / LHFS & Amortized Cost)	Allowance for Loan and Lease Losses
A.1.b	N	111	ASSETS	Total Loans and Leases (Fair Value / LHFS & Amortized Cost)	Total Loans and Leases
A.1.b	52+66-59-69	UCX3	ASSETS	Loans Held for Investments at Amortized Cost	Real Estate Loans (ex CRE Loans)
A.1.b	59+69	UCX4	ASSETS	Loans Held for Investments at Amortized Cost	CRE Loans
A.1.b	N	76	ASSETS	Loans Held for Investments at Amortized Cost	C&I Loans
A.1.3	N	80	ASSETS	Loans Held for Investments at Amortized Cost	Credit Cards
A.1.5	N	81	ASSETS	Loans Held for Investments at Amortized Cost	Other Consumer
A.1.5	N	86	ASSETS	Loans Held for Investments at Amortized Cost	Other Loans and Leases
A.1.0	N	110	ASSETS	Loans Held for Investments at Amortized Cost	Unearned Income on Loans
A.1.b	N	111	ASSETS	Loans Held for Investments at Amortized Cost	Allowance for Loan and Lease Losses