×Sorry to interruptThis page has an error. You might just need to refresh it.
Unable to find an action for 325;a: {"id":"325;a","state":"SUCCESS","returnValue":{"componentDef":{"descriptor":"layout://rl-User-VIEW-FULL----force_highlights-_1-0-674b574567657471726c42666756465a66576b5766673d3d.c"},"original":"markup://force:recordLayout","creationPath":"/*[0]","attributes":{"values":{"mode":"VIEW","offset":0,"inContextOfComponent":"force:highlights","isDraft":false,"record":{"LastModifiedDate":"2025-02-06T20:29:30.000Z","Email":null,"FirstName":"Jonathan","AboutMe":"I use Tableau by day and write about Tableau by day and night.","PostalCode":null,"Title":null,"City":null,"MiddleName":null,"Name":"Jonathan Drummey","SystemModstamp":"2025-02-06T20:29:30.000Z","CompanyName":"PATH","CommunityNickname":"jonathandrummey","Suffix":null,"Phone":null,"State":null,"CreatedDate":"2020-04-25T13:26:52.000Z","Street":null,"Country":null,"LastName":"Drummey","Id":"0054T000001O4jxQAC","LastModifiedById":"0054T000001N0mYQAS","sobjectType":"User"},"pageSize":-1,"type":"FULL"}}},"error":[],"components":[{"componentDef":{"descriptor":"layout://rl-User-VIEW-FULL----force_highlights-_1-0-674b574567657471726c42666756465a66576b5766673d3d.c"},"original":"markup://force:recordLayout","creationPath":"/*[0]","attributes":{"values":{"mode":"VIEW","offset":0,"inContextOfComponent":"force:highlights","isDraft":false,"record":{"LastModifiedDate":"2025-02-06T20:29:30.000Z","Email":null,"FirstName":"Jonathan","AboutMe":"I use Tableau by day and write about Tableau by day and night.","PostalCode":null,"Title":null,"City":null,"MiddleName":null,"Name":"Jonathan Drummey","SystemModstamp":"2025-02-06T20:29:30.000Z","CompanyName":"PATH","CommunityNickname":"jonathandrummey","Suffix":null,"Phone":null,"State":null,"CreatedDate":"2020-04-25T13:26:52.000Z","Street":null,"Country":null,"LastName":"Drummey","Id":"0054T000001O4jxQAC","LastModifiedById":"0054T000001N0mYQAS","sobjectType":"User"},"pageSize":-1,"type":"FULL"}}}]}
Tableau isn't a spreadsheet application, so doing things like adding extra columns or rows is not straightforward in one worksheet. I'm with the others in arranging a second worksheet for your 3 totals, and would probably go with something like:
// Replace 2 with 5 and 11, and replace 3 with 6 and 12 for the other averages
SUM( IF DATEDIFF('month',[Month],[Most Recent Month]) <= 2 THEN [Value] END ) / 3
where [Most Recent Month] is { FIXED: MAX([Month]) }, but could be parameterised.