Showing results for 
Search instead for 
Did you mean: 

Displaying Opening Balance for Date Range in Pivot Table

9 - Travel Pro
9 - Travel Pro

Hey everyone,

I’ve got a table with an opening balance that shows the date and total quantity on that date. There’s another table I’m working with that has transaction details and their values (transaction date and quantity).

What I want to do is display the opening balance alongside the sum of the transactions for a user-selected date range. I’ve managed to calculate the sum of the transactions, but I’m trying to figure out how to get the opening balance for the earliest date in the range.

Any ideas on how to achieve this? Thanks in advance!

Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]