Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Extracting specific rows from master XLS extract by business area — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Extracting specific rows from master XLS extract by business area

Received Response
4
Views
1
Comments
edited Jul 1, 2019 12:38AM in Narrative Reporting 1 comment

Summary

Extracting specific rows from master XLS extract by business area

Content

I have a source that produces a master extract with Actuals by category and half year, with a section total

The end report is broken up by business area and each business area just needs a subset of these categories with an appropriate change in the section totals

How can this be achieved without creating a separate custom extract sheet for each business unit

Almost needs a Business Unit - Category lookup and match on all categories that match the Business Unit lookup

 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!