on 2005 Nov 15 6:02 PM
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>
Hi
I think the answer is NO.
I think you will have to do some back end work to accomadate this.
Edan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.