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
use Table output as input to crosstab
Migrateduser
The final result of the table needs to be fed to the crosstab . How can I do this using bist 2.6.0?
what I actually need to do is:
some of the dataset columns are :
id createddate status
1 1 Jun applied
1 5 May check
1 6 May check3
2 6 Aug check
2 8 Aug applied
3 7 may applied
3 8 aug check3
3 19 may check
I need to filter them as per:
id createddate status
1 1 Jun applied
2 8 Aug applied
3 8 aug check3
so as to give me records for each id for which the created date is the latest.
I am to achieve this in a detail report that we create using the aggregation function "Last" on created date in a table.
Now I need to have a summary report (crosstab), which will show data as per status and some other columns. I do not show the id & created date in the summary.
Find more posts tagged with
Comments
There are no comments yet