#1
|
|||
|
|||
Cumulative numbers/percents using DAX
Hi
I have a data set that I load into Excel 2010's Powerpivot window and then pivot over it in Excel. For pivoting, I have been using DAX functions to create various aggregations by creating Measures within the pivot table. However, I do not know how to create a cumulative numbers using DAX functions. I have a column for 'exit month category' that contains a value (6, 12, 18, 24, 30...) that represents the month (in six month increments) a child exited from the court system. I have a bar chart that displays the exit month category on the X-axis. However, using DAX or some other Excel formula, does anyone know how I can get the record counts to aggregate as they move down the X-axis from left to right? Attached is an example that does not use Powerpivot, but uses regular pivot tables instead. Paul |
#2
|
|||
|
|||
Hi, have you tried using the Running Total calculation?
Look at value field settings for Count of Exit Month , Click on tab: Show values as: "Running Total in" , and in Base field, select ExitMonthCategory |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I refer to page numbers, when the numbers change as I prepare the document? | StevenD | Word | 5 | 11-29-2012 12:52 AM |
Numbers on the pages | Groucho | Word | 2 | 02-23-2012 02:14 AM |
Page Numbers Not Matching Chapter Numbers | gracie5290 | Word | 1 | 02-02-2012 11:41 PM |
Numbers | rdcrags | Word | 4 | 11-13-2011 11:11 AM |
Numbers Missing-HELP! | ofriendasu | Word | 0 | 07-12-2010 03:08 PM |