交叉表var-char列中的总发生次数 [英] count of total occurrence in cross-tab var-char column
问题描述
CROSSTAB报告
我有2种模式,想要在列中出现字符总和
我想要如下所示的交叉表报告,
我已经创建了它,但问题是,
当0我要显示*和1然后''a''
和每行的最后总数''a''栏目
CROSSTAB Report
I have 2 modes and want sum of occurrence of character in column
I want cross tab report like below,
I have already create it but problem is,
when 0 I want to display * and 1 then ''a''
and last total of ''a'' for each row & column
name Mode
1 2 3 Total
------------------------
a * * a 1
b a * a 2
c a a * 2
------------------------
total 2 1 2 -
推荐答案
希望它对我们有用他们有同样的问题,
这不是直接可能的,你可以按照以下步骤输出相关的输出。
i创建公式@mode,
Hope it will useful to them who have same problem,
It''s not directly possible, you can follow below steps for output like given in question.
i have create formula @mode,
iif({table.mode}=0,"*","a")
ad下面的新部分报告页脚
现在,你有2个报告页脚
1.报告页脚a(设置参数以下部分= true)
2.报告页脚b
now报告页脚a,
创建交叉表报告集col&行并在汇总字段中添加
@mode (摘要操作= @mode模式)
现在
,压制总计
将其粘贴到报告页脚b中,
选择夏季字段更改它的汇总字段= {table.mode} , (摘要操作= {table.mode}的总和)
现在,不要抑制此交叉表报告的总数
并且不显示交叉表报告中的网格线 - 2
注意,设置左上方的高度宽度等两个报告相同
它会给出欲望输出
(字符串col但数字总数)
快乐编码!
:)
ad new section below report footer
now, you have 2 report footer
1. Report footer a (set underlay following section = true)
2. report footer b
now In report footer a,
create crosstab report set col & row and add
@mode in summarized field (summary operation = mode of @mode)
now, suppress totals
copy paste it in report footer b,
select summery field change it''s summary field = {table.mode} , (summary operation = sum of {table.mode})
now, do not suppress total for this crosstab report
and do not display grid lines in crosstab report - 2
note, set top left height width etc same for both report
it will give desire output
(string col but totals in numbers)
Happy Coding!
:)
这篇关于交叉表var-char列中的总发生次数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!