Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Show same field but with different values
Migrateduser
<span style='font-family: Courier New'>Suppose I have a table w/ the following fields:<br />
<br />
EMP_ID<br />
RATE_TYPE<br />
RATE<br />
<br />
Table looks like this:<br />
<br />
EMP_IDRATE_TYPE RATE<br />
123 REGULAR 10.00<br />
123 OVERTIME 15.00<br />
<br />
When I design the report and group by EMP_ID, the report looks like this:<br />
<br />
EMP_ID RATE <br />
123 <br />
10.00<br />
15.00<br />
<br />
I'd like the report to be:<br />
<br />
EMP_ID REGULAR_RATE OVERTIME_RATE <br />
123 10.00 15.00<br />
<br />
Any ideas? Thanks.</span>
Find more posts tagged with
Comments
There are no comments yet