4 Replies Latest reply on Feb 11, 2016 5:52 AM by Dude Ma

# How to find out the percentage of A revenue difference (\$2,658,370) in the total difference (\$10,585,571).

Hi Friends,

I am trying to show in Tableau is the percentage of each row (Pro) in the total difference.

As an example, what is the percentage of Battery A revenue difference (\$2,658,370) in the total difference (\$10,585,571).

So, I need to add a new column that shows the % of each row’s revenue decline in the total revenue decline.

Below is the screenshot attached. Please help me out of it. I have attached the screenshot of it.

Please let me know if you have any doubts r clear explanation required.

• ###### 1. Re: How to find out the percentage of A revenue difference (\$2,658,370) in the total difference (\$10,585,571).

Dude,

Little bit tricky, but I used LOD and table calculation combined.

The key was how to calc Delta total.

[Month TTL delta]

{fixed : sum(if month([Month])=[Latest Month] then [Transaction] end)}-

{fixed : sum(if month([Month])=[2nd Latest month] then [Transaction] end)}

[Latest Month]

month({fixed : max([Month])})

[2nd Latest month]

[Latest Month]-1

[Percentage of ttl]

(ZN(SUM([Transaction])) - LOOKUP(ZN(SUM([Transaction])), -1))/attr([Month TTL delta]) Thanks,

Shin

9.0 attached.

1 of 1 people found this helpful
• ###### 2. Re: How to find out the percentage of A revenue difference (\$2,658,370) in the total difference (\$10,585,571).

Thanks for the reply. I'm new to Tableau so any other easy steps please

• ###### 3. Re: How to find out the percentage of A revenue difference (\$2,658,370) in the total difference (\$10,585,571).

Any other ideas please

• ###### 4. Re: How to find out the percentage of A revenue difference (\$2,658,370) in the total difference (\$10,585,571).

Any other ideas are suggestions guys