working with the data in the present structure you have 2 data sources that you blended together -
to get a total you need to bring the 2 measures together into a single viz that is associated with one of the sources from the secondary source-
The first sources you work with is the primary - when you bring data from the secondary it comes over as an aggregate so you need to create an aggregation like the one shown below -note this is a new measure not a Grand Total
you could create a viz like this
another solution is available if you could restructure the data to look like this
Source 1 Acct # Price Level Product level amount 321 Dugout Quarter Season Unrenewed Revenue $10,000 432 Field Half Season Unrenewed Revenue $7,500 543 Dugout Full Season Unrenewed Revenue $2,500 654 Home Plate Full Season Unrenewed Revenue $1,225 Source 2 Acct # Price Level Product level amount 123 Dugout Full Season Revenue $10,000 456 Field Full Season Revenue $5,000 789 Dugout Half Season Revenue $5,000 135 Home Plate Quarter Season Revenue $5,000
This data can be combined in a Union (like appending data) in a single data file (source) and can be directly summed, sub-totalled etc
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.