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

RaviKumar_Rongali05
edited February 11, 2022 in Analytics #1

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"