Hello. i have three colums.
customer Sales and month (01.2016/02.2016/03.2016...).
I want to have a liste with the sales per customer.
This is easy.
But in this list i want this colums
Customer 01.2016 02.2016 new Column 1 (02.2016-01.2016) new colums 2 ( 01.2016 + 02.2016)
A 10 6 4 16
B 8 3 5 11
C 20 2 18 22
How can i get a column what is the difference between the other 2 columns?
How can i get a column what is the a sum of the two other colums?
I hope you can understand my problem..
Here is a way. You'll have 0s where you don't have enough data to calculate the previous minus current (on the first row for every customer.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...