Transaction Pivoting allows you to analyze transaction data across all your funds directly within Maybern, allowing you to answer reporting questions immediately and eliminating the need to manually manipulate data in Excel. Save views you want to revisit, and share those views with coworkers within your organization.
Accessing Transaction Pivoting
Navigate to the Transactions tab in the top navigation menu
Click the Pivot Mode toggle in the top right corner of the transaction table
Creating Custom Pivot Tables
Basic Pivot Table Creation
Navigate to the Transactions tab (from the top navigation bar)
Click the Pivot icon at the top right of the table of transactions (located next to the search icon)
With Pivot Mode enabled, drag the fields you want to display as columns into the Column Labels box, and the fields you want to display as rows into the Row Groups box
This allows you to aggregate transaction data by specific categories
Add additional fields if desired to create nested hierarchical groups of data
By default, transactions will aggregate by capital amount (see the Tips & Tricks sections below for more information on how to aggregate data by other key fund metrics)
Filtering Your Data
Click on the Filters tab in the pivot panel
Select from the available fields to filter your data:
Fund Family
Transaction code
Investment name
Entity name
And more
For these fields, you can use the searchable multi-select dropdowns to choose specific values.
Creating and Managing Saved Views
After configuring your pivot table, click the Save As New button
Enter a name for your saved view
Choose visibility:
Organization - visible to all users in your organization
Only Me - private to your account
To modify an existing view:
Make your changes
Click Save to update the current view or Save As New to create a new view
To delete a view, open the saved view dropdown and click the delete icon next to the view name
Sharing Views with Colleagues
Open the saved view you want to share
Click the Share button
A link is copied to your clipboard that you can paste into an email or message
When colleagues click the link, they can view your exact configuration (if they have access to the same data)
They can then save it as their own view for future reference
Downloading Pivot Tables
After configuring your pivot table, click the Download button
The exported Excel file will maintain your pivot table structure and data
Tips & Tricks
When working with a single fund family, you can aggregate (sum) based on calculation values:
Use the Fund Family filter at the top of the table to select a specific fund family
In the Values tab of the pivot panel, use the dropdown to select a calculation to aggregate
The system will automatically handle positive and negative values based on the calculation definition
Note: Calculation aggregation is only available when filtering for a single fund family, as calculation definitions are specific to each fund family.
Use Cases
Create tailored reports that meet your specific requirements, such as:
Capital activity by investor and fund
Accrued management fees, offsets and breaks by investor
Unfunded metric by fund over time
Efficiently answer internal and external questions, and verify and validate your Maybern data:
Reconcile capital activity by investor
Verify calculation impact of specific transactions
Need Help?
Reach out to your Maybern Point of Contact or in the UI via chat