Different field names with same value

[remyasujith]

Hi,

I have an excel table for Target and it contains only month like Jan,Feb.This field is MONTH.

Achievement % is from other qvds and the calculation is done in set analysis . all other qvds are linked to calendar which has field Month.

for showing target and achievement in pivot table if I add MONTH to column target will show the value because for achievement it is Month. 

How to solve this. 

[Lauri]

I'm not sure what you mean. Do you want to join MONTH to Month? During load, rename Month to MONTH (or MONTH to Month). 

If you don't want to join the two fields during load, you can use the P() function in set analysis, like {<Month=P(MONTH)>}