Hi Frances, what happens if you click Analysis -> Totals -> Show Column Grand Totals? (Or Row Grand Totals, if appropriate.) Does that give you the grand totals you're looking for?
I tried that, and it gives a strange result. Instead of totals below the 3 columns in the report, it creates three new columns with just the totals. And column 3 is a percentage calculated by column 1 / column 2, but it adds the percentages rather than calculate a percentage based on the totals.
Could you post a packaged workbook for me to see? Or maybe a screenshot that includes at least the view and the row and column shelves?
There's all kinds of security around this data - maybe I can just describe it:
Columns: Type AGG( x ) AVG ( y ) AGG (% = x / y)
Rows: Unit Subunit
x and y are Measures. I don't understand the AVG
We have copies of this report from two weeks ago, and there are Grand Totals. Now there are none.
Is this displayed in a text table, or is it some kind of graph?
Its displayed as a bar graph
There are about 12 rows
1 5 20%
20 22 91%
This is difficult to troubleshoot without being able to see it, but here are a couple suggestions based on what you've told me:
- When you enabled grand totals, did you try both types of grand totals? It sounds like you enabled Row Grand Totals but need Column Grand Totals instead.
- Is it possible that the report came from a dashboard instead of a sheet? Have you tried looking at all the other tabs in the workbook?
1. I did try column grand totals and got the strange result. Row Grand Totals does something completely different.
2. I have looked at the other sheets. No help.
I was hoping to find the change in Tableau that caused this report to suddenly stop working. From looking around this site, it appears that Grand Totals have become more complicated - perhaps Tableau discontinued an older feature?
I haven't seen any changes to grand total calculations in the last several changelogs, but maybe someone else knows of one. I would guess it's something else, though.
I had the same problem when I tried to get subtotal where I got totally different numbers. Check it out below link as Jonathan Drummey talks about why it is happening and how you can get right subtotal. Overall, Tableau does calculate subtotal totally different than how it should be calculated. He explained everything in detail so it is worth to read. Hope it helps your concern.