Home Analytics Developing analytics applications
The community of Analytics developers are invited to follow and participate in the developer network.
OpenText technical experts collaborate with supported customers and partners in the Magellan product area.

How to use one data set output to create another data set dynamically

I have one data set as below

final result should be like below. each deal should get the accumulated Debit and credit based on it's parent deal id.

Answers

  • You can achieve this by doing all your calculations in a stored procedure and access that stored procedure in a Data Set of type "SQl Stored Procedure Query"

Sign In or Register to comment.