Percentage of Growth

16 views
Skip to first unread message

Reinaldo_Junior

unread,
Nov 30, 2011, 8:17:23 AM11/30/11
to InterSystems: DeepSee Community
Hi all!

In DeepSee 2, what is best way to create a Pivot Table that shows the
percentage of growth for a given measure and time period?

Eg: I'd like to see the percentage of growth for new patients, for the
last 4 months, for Site A.

Let's consider these values:

July = 8 new patients
August = 10 new patients
September = 8 new patients
October = 12 new patients
November = 15 new patients

I'd like to see a pivot like this. Each column calculates the
percentage considering the previous month (August compared to July,
September compared to August, and so forth):

August September October November
25% -20% 50% 25%

Thanks in advance.

Reply all
Reply to author
Forward
0 new messages