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
Need to display same data twice in the same table with some filtering
Migrateduser
Hi,
I have a table that binds to one dataset. Inside the table, I inserted a group on EmpID.
Now on the first row, I want to display all the records where EmpID = 103 and do the aggregation sum on their salary and display the Total below it.
On the second row(same table), I want to display all the records where EmpID <>103 and do the aggregation sum on their salary and display right below it.
This is kind of a filtering but is there a way I can do this within one table one dataset? Or do I need to create a second dataset and then insert the second table inside the first table to accomplish what I need?
Please let me know I would appreciated.
Thanks.
Find more posts tagged with
Comments
There are no comments yet