5 Replies Latest reply on Sep 1, 2016 4:14 AM by Luciano Vasconcelos

# Calculating a new Subtotal

Hi everyone,

I starting with tableau and I need to do this report.

If you look... after each group (1 AV, 2 SE, 3 SAV) I must to make a difference between the current period and the previous period (70.894 - 69464 = 1430).

Obviously this must be dynamic, When will august finished, this data add after '201607'.

In tableau, the subtotal sum all of values. So I need to know if possible change this calculation by a formula, or another way.

Thanks

--Arturo

• ###### 1. Re: Calculating a new Subtotal

Hi - Do you mean instead of adding the values , you want the difference between values. ? If yes at what level of data .Can you send an excel sheet to explain the expected output.

Regards,

Rashmi

• ###### 2. Re: Calculating a new Subtotal

Hi Rashmi and thanks for your help.

Yes, I need the difference between the last two values for the first group

• ###### 3. Re: Calculating a new Subtotal

See this one.

• ###### 4. Re: Calculating a new Subtotal

Luciano

This works perfect!!!

Thanks very much

• ###### 5. Re: Calculating a new Subtotal

Consider that this solution works for the some year ok?

For year switch you'll need adapt.