Display the Missing values

[#1]

Hi All,

I have two tables one is Demand, other one is Given

Demand table contains Project Number, SPID, Mgr, Month, Demand

Given table contains Project Number,PID, Month,Given

i want to display Mgr wise Given and Demand details as follows

this is done, But my req is i want to display only the values which are 0(Zero) in Given column or (missed data from Given data when compare to Demand Data) with respect to Mgr as follows

I attached Sample QVW and Data file, Please have a look into this req and give me some suggestion.

Thanks,

Chiru

[karolina_]

Please check attachement.
Is it what you expect?

[#3]

Hi Karolina,

Thanks for reply, But my req is here PID and SPID are same you can observe PID 3,7,8,9 are not existed in Given Data but they are existed in Demand data.

I want to show the values which are not exists in Given data when compare to Demand data for those values i want to show the field value as zero.

Please help me on this.

Thanks,

Chiru

[neha_shirsath]

Hi Chiru,

Please find the attached file.

Hope it'll help you.

-

Neha