Calculating the Year Over Year Difference of the Percent Of Total
09 Mar 2016
Last Modified Date:
12 Mar 2018
How to obtain the year over year difference of the percent of total of a measure.
In order to achieve the desired behavior please follow the steps detailed below:
1. Use the following two options in a Calculated Field:
Name: Percent Difference
(ZN([Percent Of Total]) - LOOKUP(ZN([Percent of Total]), -1)) / ABS(LOOKUP(ZN([Percent of Total]), -1))
Name: Absolute Difference
(ZN([Percent Of Total]) - LOOKUP(ZN([Percent of Total]), -1))
Ensure to have a Date Hierarchy to use in the Computing of the above Calculation
2. Right-click on [Absolute Difference] or [Percent Difference]
Edit Table Calculation
3. Select the following:
Compute using: [Date Field]
At the level: Year of [Date Field] (use
for Year over Year,
for Month over Month etc...)
Did this article resolve the issue?
Thank you for providing your feedback on the effectiveness of the article.
Click here to return to our Support page.
Open new Case
Open a new case
Click here to go to our Support page.
Get detailed answers and how-to step-by-step instructions for your issues and technical questions.
Find and share solutions with our active community through forums, user groups and ideas.
Browse a complete list of product manuals and guides. Available online, offline and PDF formats.
Training and Tutorials
Learn how to master Tableau’s products with our on-demand, live or class room training.
PRINT THIS PAGE
Difference from last year Column Percent
SUPPORT BY PRODUCT
TOOLS & DOWNLOADS
Download Tableau Desktop & Server
Tableau Online & Public Status
Send Large Files
All Tech Specs
Elite Account Management