hercule_legume
New Member
- Joined
- Aug 21, 2018
- Messages
- 1
Hi,
.
I'm trying to sort a pivot with financial statement line items with a few parent categories. The idea is once it calls up trial balance amounts/time series it should look like an actual income statement/balanace sheet etcI have a hierarchy defined (below link). Could anyone give me a tip with respect to sorting this hierarchy? I have defined unique/incrementing identifiers and I have tried using a defined list but I'm not getting the hang of it. Any advice appreciated.
https://drive.google.com/open?id=1DkVDc5N7x4v-6ICQtYqzkwn3dSVSbLbf
Thanks,
H
.
I'm trying to sort a pivot with financial statement line items with a few parent categories. The idea is once it calls up trial balance amounts/time series it should look like an actual income statement/balanace sheet etcI have a hierarchy defined (below link). Could anyone give me a tip with respect to sorting this hierarchy? I have defined unique/incrementing identifiers and I have tried using a defined list but I'm not getting the hang of it. Any advice appreciated.
https://drive.google.com/open?id=1DkVDc5N7x4v-6ICQtYqzkwn3dSVSbLbf
Thanks,
H