3 Replies Latest reply on May 14, 2018 6:54 AM by Shinichiro Murakami

Difference From Static Value

Hello,

I am trying to find the difference from the value from first row by keeping it static.

For example, to calculate formula for diff1 is :

B5= \$B\$3-B4 , C6 = \$B\$3-C4, D7=\$B\$3-D4 and E7=\$B\$3-E4

which means I am taking the difference from B3 and the cells from next row

Same goes for other Difference Diff2, Diff3 and Diff4 but this time with next value in row if ship mode, that is:

For Diff2,

B5=\$B\$3-B4, C5=\$B\$3-C4 and so on.

I have attached excel sheet and twb for reference. Quick response is appreciated

• 1. Re: Difference From Static Value

Hi Nitin,

The calculations themselves can be written as below.

You cannot specify the "Cell" in Tableau, but can specify the value of dimensions.

FYI

Overview: Level of Detail Expressions

Table format is different discussion and I just put two tables on dashboard

.

Thanks,

Shin

1 of 1 people found this helpful
• 2. Re: Difference From Static Value

Thank you so much for quick answer. It really helped me.

I have a question - why did you take min function instead of sum outside Fixed LOD?

• 3. Re: Difference From Static Value

Hi Nithin

In LOD calc, it' already summed up.

Then to make LOD as aggregated value, need to add some aggregation including attr, min,max, avg, sum  whatever.

Using min is my preference because typing min is shortest finger moving.

Thanks,

Shin