I try to calculate the net growth/ loss for two dimensions in Tableau. On columns I have the dimension “current State”, on rows I have the “previous State”. I want to calculate the percent difference the “previous State” dimension to the “current State” dimension. I thought this would be quite simple, however I just cannot figure out how to do it.
Right-click on the measure being summed and select "quick table calculation > percent difference". You can right-click it again to select how it calculates with "compute using". You'll have to add another copy of your measure to the view if you want to view the raw totals as well.