Help needed with data presentation

[amit_shetty78]

Hi All,

I need some assistance on how to get the result in the way shown below.

I have an application which loads data from 2 different databases and I am trying to put together a deck to show the correlation between them. The 2 datasets are linked via column [Item Name].

For E.g.: Dataset 1:

RecordNumber	[Item Name]	RecordDate
1122	Item1	4/1/2010
1344	Item2	4/12/2010
4532	Item3	4/13/2010

Dataset 2:

SrNo	[Item Name]	[Date Of Entry]
4567	Item1	3/31/2010
4568	Item1	3/31/2010
3456	Item1	3/20/2010
2233	Item2	4/11/2010

I want a pivot that will tell me if there was a record for an Item on a particular RecordDate then also show me the corresponding SrNo/s if any for the same Item say in the Last 24 hours based on [Date of Entry].

Result I am looking to have:

Item Name	Record Number	Record Date	Sr No	Date of entry
Item1	1122	4/1/2010
			4567	3/31/2010
			4568	3/31/2010
Item2	1344	4/12/2010
			2233	4/13/2010
Item3	4532	4/13/2010

I think I can achieve this with 2 separate tables. When I select a RecordNumber in table 1 then based on the corresponding RecordDate I can show the SrNo/s in the last 24 hours in table 2 but I am looking to show it in just one table as shown above.

Appreciate any kind of help on this.

Thanks.

[pover · Accepted solution]

Is there a reason SrNo. 3456 doesn't exist in the resulting pivot table?

Create one pivot table with Item Name, Record Number, Record Date and Sr No as dimensions and only([Date of entry]) as the expression. That should give you the result you are looking for.

Regards.

[#3]

Hi Amit,

Pls find the attached application which will help you.

Regards

Rajesh

[#4]

Hi Rajesh,

Cant find a attachment.

- Sridhar

[#5]

Sorry missed the attachment

[amit_shetty78]

Rajesh and Karl, Thanks for the help.I'll try it out and let you guys know.

Best Rgds.