Overview
The Investment Distribution tab rolls up holdings from the Holdings tabs into a three-ring sunburst chart that allows you to show a wide range of how your investment costs, assets, gains, and losses are distributed across categories and levels - including institution, account, and account group.
Additionally, the tab is built to support a custom Category and/or Subcategory column in Holdings where you can create your own aggregations.
Figure: Showing hierarchical distribution of current value down Account Group → Holding Type → (my custom) Category dimensions
Questions you may find the Dashboard useful in answering
- What is my overall asset allocation across every account?
- Where are my gains and losses, and what are my relative gains by account type, holding type, or custom category I care about?
- Are certain sectors or holding categories outperforming others (based on their percent of gains exceeding their percent of investment)?
Installation and Setup
Link to the clean spreadsheet with mock data: Investment Distribution Tiller Template
- Copy the Investment Distribution tab into your Tiller Google Sheet with the Holdings feature added (right-click the Investment Distribution tab at the bottom, choose Copy to > Existing spreadsheet, pick the destination sheet and click Insert)
- Rename the tab to Investment Distribution (though not strictly required)
- Optional: Add new columns: Category and/or Subcategory to your Holdings Tab. These allow you to create custom aggregation levels based on your questions of interest (they do not need to be filled in, and the sheet does not require the columns)
- In the Holdings Tab, enter “Hide” (case doesn’t matter) in Category or Subcategory for any specific holding you want to ignore in the Investment Distribution sunburst
- In the Accounts Tab, fill in the Group if you want to group your Holdings accounts, and fill in Hide for any Account that you want to ignore in the Investment Distribution charts
- Configure the parameters you want and go!
Usage
Configuration Options
- Data Filters (C2-C8): Blank includes everything, or select values to filter the source data.
- Field Shown (inside pie:H2, middle: I2, outside: M2): Select the dimension to show in each ring (only fields that have data appear as options)
- Value (H3, I3, M3): The metric to show:
-
- Current Value, Cost Basis, Net Gain, Percent Gain
- Net Loss and Percent Loss show the same data as Net Gain and Percent Gain in the Series Data, but determine what is visualized in the starburst
- Slice Label (H5, I5, M5): The text printed in each slice (Label, Value, % of the pie). Note: do not manually edit the charts to change the charts’ slice label!
- Align (H4, I4, M4): Selecting Yes sub-aggregates the ring field based on it’s parent and sorts the data in the ring to match, when possible. This allows for dependent views across starburst rings. See the align examples below for a more intuitive example
Using the Dashboard
The Aggregate Source Data Table (Columns Q:AB) pulls and aggregates all of your holding information (along with Account Group). This does not change as you alter Filters/Configuration
The Series Data Tables (B44:O) shows the subaggregated data based on your selections and configurations.
The Sunburst (A9:I43) are actually 3 separate charts (since Google Sheets does not have a real starburst) that visualize the Series Data
Warnings and Notes
Google Sheets can be a little finicky, so please note the following:
- Do not manually change the charts’ slice labels - use the Configuration to switch between Label/Value/%
- Since it’s a pie chart, it can’t display positive and negative numbers together - so to see losses in the starburst, select Percent Loss or Net Loss fields
- ““Percent”” means Percent Gain/Loss in some places and Percent of the Pie in others - So the Slice Label should be set to ““Value”” to see the Percent Gain/Loss on your cost basis and “”%“” to see the percent of the total gain/loss represented by each slice (i.e., sum(percent of pie) = 100%; sum(Percent Gain/Loss) does not)
- Sadly, at some zoom settings the starburst rings may become slightly unaligned with each other - try setting the zoom close to 100% if this happens
Understanding “Align”
Case 1
Consider Institution (inner pie) - Holding Type (middle and outer rings), all with Cost Basis values: Align here shows Hierarchies
By default, these are independent and so the inner pie shows the distribution of your cost basis across Institutions, and the middle ring shows the distribution across Holding Types:
Figure C-a: distribution by institution and distribution by holding types, inner pie and outer rings are not aligned or related
With Align = YES, each slice is actually “Institution - Holding Type” and the same holding type appears for each institution; thus, you visualize holding differences within each institution. When the Value Type is the same, these will be visually hierarchical and the outer rings will show sub-distributions of the inner rings:
Figure C-b: distribution by institution and then holding types ALIGNED to institution: outer ring categories now are sub-divided by inner pie institutions
Case 2
Now Consider Holding Type / Cost Basis (inner) - Holding Type / Current Value (middle) - Holding Type / Net Gain (outer) : This will show you how the distributions of your holdings change between the cost / value / gain, and the colors will represent the same holding type. Note that the starburst will not be visually hierarchical when the value types differ - and this shows you how the distributions are different given the different types!
Figure: holding type progress from Cost Basis to Current Value to Net Gain, to show how the distributions are different
Permissions
Copy, use, and modify your workflow - absolutely!
To the degree relevant:
Licensed under the MIT License, https://opensource.org/license/mit, which means
you are free to use, modify, and distribute this formula without restriction,
but you need to attribute the original author (and add yourself if you make changes).
Copyright Kevin Crouse, 2026.
FAQ
Optionally, add common questions and answers…



