交叉表中的计算字段 [英] Calculation field in Cross Tab

问题描述

嗨
我不知道这是否可能.我真的希望是.

我有一个交叉表，按产品类将数据汇总为列，并按ClassName，BranchName，CustomerName汇总行.摘要数据包含上一年和当年的GrossValue.

现在的百万美元问题.现在，我想要一个公式，该公式将采用当年 GrossValue/上一年的GrossValue * 100 给我百分比差异.

我将如何去做?仅放入公式并不能正确计算.

亲切的问候，

Elizma

Hi
I dont know if this is possible. I really hope it is.

I have a Cross Tab that summarise data by a Product Class as columns and the rows by ClassName, BranchName, CustomerName. The summary data contains the GrossValue of the previous year and the current year.

Now the million dollar question. I now want a formula that will give me the percentage difference by taking the current year GrossValue / previous year GrossValue * 100.

How will I go about doing this? Just putting in the formula does not calculate it properly.

Kind Regards,

Elizma

推荐答案

去这里

水晶报表:在交叉表中计算 [ Crystal Reports 2011:将计算添加到交叉表 [ Enterprise 4.x的晶体报告:添加交叉表的计算 [ ^ ]

Here you go

Crystal Reports: Calculate Inside a Crosstab[^]
Crystal Reports 2011: Add a calculation to a crosstab[^]
Crystal Reports for Enterprise 4.x: Add Calculations to a Crosstab[^]

这篇关于交叉表中的计算字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！