2 of 2 people found this helpful
Just to add to Norbert, it seems the pills you brought in are discrete - currently, Tableau is treating these pills like a Dimension (like "text") which is why the grand total isn't showing a total aggregate. What you want to do is convert each of your measures "2016 Adjusted", "Decreased Count", etc. to continuous (images below).
- You can either switch each pill in the rows (image 1) or, what I'd recommend, is going to the Dimensions all the way on the left and change them to continuous (image 2). That way you can use these in aggregations in other sheets. Note: Once you switch the pills to continuous you will notice they turn green to signify a measure.
- Once we change all the measures to continuous, i'd remove all the pills from the rows except what you'd like to categorize by, which seems to be "Accountable Medical Group".
- Then, you can double-click or drag-and-drop each measure into the worksheet next to "Accountable Medical Group" (image 3). Note: After you add more than one measure you'll notice Measure Values and Measure Names appears (image 4).
- After you bring in all your measure pills, you can add in your column grand total and you should see the values are now populated.
Hope this helps!
(image 1) (image 2)
(image 3) (image 4)
Thank you Bobby, this was EXTREMELY helpful. I'm back into business now.
Thank you! You've been a big help.
This makes total sense. Thank you for the assistance!