I am trying to create a year over year percent difference calculation based when the dimension is in the column.
So I'll year years in the column and the table will look like what's below:
Subject 2012 2013 2014
MATH 23 34 37
HISTORY 9 7 8
READING 54 61 58
So what I'm looking to do is create a calculated field for a percent difference from 2014 compared with 2013.
Appreciate the help!
Is this what you're looking to do?
IF LAST()=0 THEN SUM([Grade])/LOOKUP(SUM([Grade]),LAST()-1) END
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...