Cognos Report Studio小计 [英] Cognos report studio group for subtotals

问题描述

我有此报告，该报告按专栏城市分组。当我在金额字段中添加总计时，它不会显示每个城市的小计...最后只是总计。

如何添加

解决方案

您获得了一个简单列表并将其拖动到其中，您希望将其分组以及您想要汇总的数据。在我的示例中，我使用了商店，年份和销售量：

现在您选择第一列，在我的示例商店中，然后单击按钮I在屏幕快照中标记为红色：

对第二列执行相同的操作，在我的示例中为 Jahr / Year。

之后，在包含您要测量的数据的列上单击，在我的示例 sales volume / AuftragGesamt中，然后单击带有总和符号的按钮。然后，您可以选择如何汇总数据。

您在每个商店下都有一行，持有每个商店的总和。最后，在最底部，您将连续持有所有商店的总和。

I have this report which is grouped by column cities. when I add a total to the amount field, it doesn't display subtotals for each city... just a grand total at the end.

How do I add a subtotal row in Cognos report studio?

解决方案

You got a simple list and dragged the columns into it, which you want to group by and the data you want to sum up. In my example here I used "Shop", the "year" and the "sales volume":

Now you select the first column, in my example "Shop" and click on the button I marked red in the screenshot:

Do the same for the second column, in my example "Jahr / Year".

After that, click on the column which holds the data you want to measure, in my example "sales volume / AuftragGesamt" and click on the button with the sum symbol. Then you can choose how to aggregate the data.

As you can see multiple rows were added. You got a row under each shop, holding the sum for each shop. And finally at the very bottom you have a row holding the sum for all shops.

这篇关于Cognos Report Studio小计的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！