使用表计算时,值将根据视域和所使用的计算类型而有所不同。例如,table down
将从上至下进行table across
计算,从左至右进行计算。这样,您将看到许多其他计算选项。
In below example I have used running total
with table across
that is direction from Left to Right
column values (2014,2015,2016,2017,2018)
.
Example:
Image1 - Original Data(without table calculation)
Data with table calculation - running total(table across)
In below image, Left to Right
values are Ship Dates against Segments
. Look at the Yellow color highlighted row. Year 2015
for Consumer Segment
the sales value is 40,656
but in the original data(Image1) it is 24,635
. The reason it is showing 40,656
is because table calculation is performed with running total by table across(left to right)
, so the original value 24,635 is added with previous Year's(2014) value 16,021
. Hence 16021 + 24635 = 40656
. It means Left value(16021)
is added with the Right value(24635)
. This pattern will continue till the right most value.
Image2
列和行被切换
在以下图像(的Image3)Left to Right
的值是Segments against Ship Dates
。列和行被切换。值Corporate
段为2014年更改为25950(blue circle)
,因为left side value 16021
是added with the original value 9929(Image1)
。
图3
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句