summarizing contents of a row/column in a single cell (acc. to given conditions).

[ajay1303]

verticals

exp heads (EH)

V 01

V 02

V 03

V 04

V 05

V 06

V 07

V 08

V 09

V 10

V 11

Total

01

1.2

2.3

4.0

3.6

1.1

2.5

3.4

1.9

0.4

2.1

1.3

23.80​

02

8.00​

0.37​

0.00​

0.18​

5.00​

0.08​

0.51​

0.00​

0.27​

0.00​

0.00​

14.41​

03

0.00​

0.18​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.00​

0.18​

04

0.00​

0.00​

0.00​

0.00​

0.00​

0.07​

1.64​

0.00​

0.06​

0.00​

0.00​

1.77​

Total

9.20​

2.85​

4.00​

3.78​

6.10​

2.65​

5.55​

1.90​

0.73​

2.10​

1.30​

40.16​

EH 01

V 04 (Rs.4 cr, 9.96 %), V 03 (Rs.3.6 cr, 8.96 %), V 03 (Rs.3.4 cr, 8.47 %), V 02 (Rs.2.5 cr, 6.23 %), V 02 (Rs.2.3 cr, 5.73 %), V 02 (Rs.2.1 cr, 5.23 %), V 01 (Rs.1.9 cr, 4.73 %), V 01 (Rs.1.3 cr, 3.24 %), V 01 (Rs.1.2 cr, 2.99 %), V 01 (Rs.1.1 cr, 2.74 %), V 01 (Rs.0.4 cr, 1 %),

The cell in bold is the output required. The given data is a matrix of Expense heads & Verticals. For every Exp. head, Verticals are to be given (along with the index head/code) in a descending magnitude order (along with the amt. & % of grand total). In certain cases, where some verticals may have '0' amt., the verticals listing should stop.