How to Merge 2 columns Year filed into one?

[#1]

Dear All,

I get my data from 2 table sources, so one is suppose is called AExpiredDate and another one is BExpiredDate

so i wish to display these two in to one instead.

for example data source A

AExpiredDate    Amount

--------------------    --------------

2012/02/03           12

BExpiredDate   Amount

---------------------   ---------------

2012/03/03           8

So, i wish to get my result like below

ExpiredYear      Amount

-------------------    ----------------

FY2012                 20

The Dimention i written something like this.. :

if((Var_Tenant_Name<>'Vacant' and Var_Tenant_Monthly<>'Y') ,'FY' & Year(Var_Tenancy_Expiry),

  if(Var_Tenant_Name<>'Vacant' and Var_Tenant_Monthly<>'N','Monthly Tenancy' ))

how am i going to merge this two different field into one?

Hope to hear from the solution..

[hic]

You should concatenate the two tables. Make sure to rename the two date fields so they are named the same.

And then you should add a Master calendar where you define your Year.

Then you can create a chart to display the table you want.

[#3]

HI JEFFREY,

First u  should have to concatenate n  rename the two field in to a single field by using alias and concatenate function.

Please find the attached qvw, hope it ll helps u.

Warm Regards,

Arun Prasadh.N.

[#4]

HI This is an updated qvw.

please find the attachment.

hope it helps.

Regards,

Arun Prasadh.N.

[divyanshi]

in thi qvw ,you have 4 amounts only ...if we have 100s of amounts then what we have to do ?