Joining between tables

[narender123]

Hi Guys.

I have shown the data modeling diagram in attacment.

In the attachment , Declaration_Header table i have created a "newkey" based on Receipt_Date like Month(Receipt_Date) &'-'&Date(Receipt_Date) &'-'&Year(Receipt_Date) as newkey and connected it to Master calender its working fine.

But In Risk_Risk_Analysis_Details table I want to count  "Raid_Field1" based on   "Rad_Revision _Date"  ."Rad_Revision _Date" is the Date of  Raid _Field1.

What should i do????? With same Joins??

[narender123]

Anyone give me some suggestion on this??

Thanks

[#3]

i think

you count the "Raid_Field1"  on the basis of  "Rad_Revision _Date" .

then

in pivote table

dimension--Rad_Revision _Date

expression--count(Raid_Field1)

[narender123]

Actually the dimention is "Consignee_Registraction" that is in Decleration Header Table.

With same joins it gives the count on Year that is made through Receipt _date.I want count based on "Rad_Revision _Date".

So Tell me what i have to do??

Thanks for the reply.

[narender123]

Hi Guys.

Need your help please..

Thanks