Add Rows to Nested Table | Group | Offset

ExcelQuestion

New member
Joined
May 27, 2018
Messages
26
Reaction score
0
Points
0
Excel Version(s)
Office 365
Dear Experts,
I hope you're all doing well.

1) How do you add each current row's [GL Code] and [Dr./(Cr.)] into each nested table?
2022-03-13_05-15-56.png

2) Here's the desired result:
a) Grouped by [GL Code] then,
b) Offset amounts to [GL Code = 2010] <<< how do you do this?
Capture.PNG

3) For cleaner M codes, my current Table.AddColumns took 6 steps [Taxes.1], [Taxes.2], [Taxes.3], [Taxes.4], [Taxes.5], [Taxes.6]. Is there a better way?
Sample file is attached.

Thanks in advance,
Ricky
 

Attachments

  • 1 Sample.xlsx
    24.7 KB · Views: 11
Back
Top