Create Indent Dimensions and rollup

[manojkulkarni]

Hi All,

I am looking for some suggestions or help on how do we get the indent dimension columns from script and use in the report to give me the rollup numbers. Here is the sample data and required output.

Any suggestions or solutions will be much appreciated. Thanks

Sample Data

Col1	Col2	Col3	Amount
Cash and Equivalents	Cash	CA1	10
Cash and Equivalents	Cash	CA2	20
Cash and Equivalents	Cash	CA3	30
Cash and Equivalents	Cash	CA4	20
Cash and Equivalents	Cash1		100
Cash and Equivalents	Cash2		20
Equity	EQ	EQ1	10
Equity	EQ	EQ2	20
Equity		EQ3	50
Account Receivable	AR	AR - Vendor	25
Account Receivable	AR	AR 3rd Party	24
Account Receivable	AR2	AR - Rent	50

Expected Output

	Category			Amount
	Cash and Equivalents
		Cash	CA1	10
			CA2	20
			CA3	30
			CA4	20
		Cash Total	80
		Cash1		100
		Cash2		20
	Cash and Equivalents			200
	Equity
		EQ	EQ1	10
			EQ2	20
		EQ Total		30
			EQ3	50
	Equity			80
	Account Receivable
		AR	AR - Vendor	25
			AR 3rd Party	24
		AR Total		49
		AR2	AR - Rent	50
		AR2 Total		50
	Account Receivable			99
Total				379