资源使用报告 [英] Resource Usage Report

问题描述

大家好

我正在尝试构建资源报告，该报告按月显示资源使用情况。因此，报告需要显示包含资源名称的行，列为月份的列（例如1月12日，2月12日，3月12日等）

I am trying to build a resource report, which displays resource usage by month. So the report needs to show rows with the resource names, the columns which are the months (e.g Jan 12, Feb 12, Mar 12 etc etc)

除此之外我们要格式化细胞说它的100％是红色还是80％琥珀色等。

As well as this we want to format the cells to say if its 100% its red, or 80% amber etc.

但首先我想，我会去报告数据库并写一个查询。但我无法弄清楚要放在一起的东西。任何人都可以帮忙查询，让我开始吗？

But first things first I guess, I was going to go to the reporting db and write a query. But I cannot figure out what to put together. Can anyone help with a query, to get me started?

推荐答案

项目学习者，

您有几种选择。如果您想报告工作和成本，您可以使用olap立方体。作为"数据透视表"的一部分报告利用OLAP多维数据集，您还可以应用条件格式化 只需使用Excel。我可以想象
这对你有用。

There are several options you have. if you wish to report against work and cost you can utilise the olap cubes. As part of your "Pivot table" report utilsing the OLAP cubes you can also apply conditional formating  simply using Excel. I can imagine that this will do the trick for you.

希望htis帮助

这篇关于资源使用报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！