Answered by:

How to create KPI from numbers which the desire is trending down

Question

If we have a measure with different Descriptions (Paper Use vs Electronic replacement in document storage), how would we use figures from 2012 to show a downward trend visually of this usage going either up or down?

I am not even sure how to ask this question but I have a column called Total. This stores numbers from different offices of, say, paper usage. There must be an average across the company or across different offices which will show this column
Total and how the figures are trending.

If, for instance, in our Kansas City office, in 2012 we used 13M pieces of paper and in 2013, we use 11.5M, am I able to create a KPI based on those 2012 numbers show show decline visually, other than a graph?

Still not making sense but I would also like to expand on this idea and show a decline for, say, a quarter vs last year same quarter.

Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.