Urgent Query Help

17 Views

Hi Gurus,

I have a report, where data looks like this:

=====================================================

Profit. Center | Y_Project | Market.Org | Actuals

ABC | Y_100_1 | Corp.Event |

ABC | # | Corp.Event | $2000

=====================================================

we are expecting the report to look like this:

<b>

Profit. Center | Y_Project | Market.Org | Actuals

ABC | Y_100_1 | Corp.Event | $2000

</b>

Details: All Y_Projects are assigned to Profit.Centers, all Profit.Centers are assigned to Market.Org. but Y_Projects are not assigned to Market.Org.

I need to merge values, for those y_projects values which doesnt have data (assigned i mean "#") to same market.Orgs. for example there are 2 market ors "Corp.Event" for which there is one "#" y_project. but i want to show as single record.

=====================================================

Profit. Center | Y_Project | Market.Org | Actuals

ABC | Y_100_1 | Corp.Event |

ABC | # | Corp.Event | $2000

=====================================================

<b>

My question, is it possible to create a query which checks for

((Profit.Center == Profit.Center) and (market.org == market.org) and (y_project == y_project)) so that it can return single row.

its urgent please help me.

</b>