How to bring calculated fields under one dimension

[#1]

Hi Everyone,

Following is a sample of a template that i want to develop -

PL Mapping	Currency Value for Admin	Currency Value for HR
Interest (A)	123	445
FTP Expense (B)	456	123
Net Interest Income (A + B)	579	568
FEI	23	87
ACBD	34	86
FTE	45	43
Non-FTE	56	21
Non Funded Income (NFI)	158	237
Total Income (NII + NFI)	737	805
Provision	78	78
Realized	98	98
Non-Realized	10	10
Total Segment	186	186

I am having the dimension as PL Mapping which is given below -

PL Mapping
Interest (A)
FTP Expense (B)
FEI
ACBD
FTE
Non-FTE
Provision
Realized
Non-Realized

I would like to add these Calculated fields in my dimension column which are mentioned below -

Net Interest Income (A + B)

Non Funded Income (NFI)

Total Income (NII + NFI)

Total Segment

Can anyone please help me in how can i achieve this ?

Thanks in advance!

[varshavig12]

pick(match())

[Anil_Babu_Samineni]

What are the A & B - Do you mean A is Admin and B is HR Values / What

[tresesco]

Have a look at : How to Create a Profit and Loss Statement in QlikView

[varshavig12]

You can try this:

[#6]

This made me understand how it will work.

Thanks