I am trying to build a balance sheet but I did not find any article about it.
So i create a saved search in netsuite that is linked to metric in Pigment by using a transaction list.
I’m trying to display data for multiple periods ( ex: dec 21, dec22...) in the same metric but looks like i have to create different transaction lists for different periods and then create a table to aggregate all the periods.
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/6bbb3222-184d-4d06-b3f8-769428d00137.png)
Happy to have your insight on the most efficient way to build a balance sheet,
thanks