4 Replies Latest reply on Feb 1, 2019 6:26 AM by Bill W

# Month over Month Percentage change with single segmented dimension

Afternoon Tableau Friends,

I am trying to create a month over month percentage change for amounts by year / month and team.

I've tried a few different options:

First, utilizing the percentage difference function built in then putting it at the month level... Which it gets close to my expected answer however I missing the other values - Team J and Yeam Y Values in November 2018, and for some reason Team B has a value which doesn't make sense. Also, Team S is way off for Jan 2019 showing 34,918% when it should be -15.33% (6303-7444) / 7444

Second, tried - zn(sum([Amount]) - lookup(zn(sum([Amount])),-1) / abs(lookup(zn(sum([Amount])),-1))) - However this did not work either.

Any help would be much appreciated.

-Bill

• ###### 1. Re: Month over Month Percentage change with single segmented dimension

Hi, Bill

Not sure where you stuck, it looks your figures are correct. can you explain a bit more?

ZZ

• ###### 2. Re: Month over Month Percentage change with single segmented dimension

I came across this as well. However, I need the Date and Team to be in the columns so I can create a secondary axis chart from the results.

Basically showing the trend, so unfortunately it has to be in columns.

Any thoughts around that?

- Bill.

• ###### 3. Re: Month over Month Percentage change with single segmented dimension

Please find my solution attached as well as screenshot below for reference.

Hope this helps

ZZ

• ###### 4. Re: Month over Month Percentage change with single segmented dimension

Appreciate it Zhouyi.

Worked like a charm.

Didn't know you could move the order of the specific dimensions.

-Bill.