the problem is the difference in how these Table Calculations are calulcated: the one from the wizard uses a only 'month' - and disregarded the category. The 'hand made' one uses 'table down (probably what you need).
Attached workbook (Tableau 10.1 version of your workbook) shows the right values with a 'standard' table calculation - using pane down, but you can also use 'specific dimensions' and 'month' + 'category'
Hope this solves your problem - otherwise let me know!
Johan de Groot
MoM issue.twbx 1.2 MB
So the difference comes from the Compute Level in the Table Calculation being different...
When you specify to Compute Using = Month...it uses Month to determine the %age Difference and restarts this calculation each Category (as Category isn't specified in the Compute Using the calculation get's partitioned on Category).
When you specify to run Table Down..it adds all "Downward" dimensions in the Compute Using, so doesn't restart the %age Difference Calculation each Category (it just keeps the % Diff calculation running down the page).
If you set the Compute Using to be Pane down...as the Category is in the Pane, it does the same as the Compute Using = Month, as now only the Month is in the Compute Using.
Hope that makes sense.
Thank you for clarifying the difference between pane down, and table down. It did help in getting a better picture of what to do next.
Have a great day!!
No problem, glad it helped.
I would add that although the formatting was part of it, your 2 calculations were returning different results. Although they both start the same, when you get to the next category there is a difference...the Compute Using Month re-starts, whereas the Table down keeps going, giving the MoM for the last month of Furniture, to the first Month of Office Supplier.
If you look at my screen grab, I've captured the difference.