Hi  i am trying to create an aggregated measure (average based on date hierarchy level)  to be displayed on a line chart on SAS VA.  if i am on day level in hierarchy  i need to calculate the average per day (Total Sum/Number of days in the level), when i am on month level the calculation should be (Total Sum/Number of Months in the level), and so on. the data should resembled like the following:- month    no. of months        profit       average per month (sum of profit /count of months) jan                3                          6               9 feb                3                          9               9 mar               3                        12               9   so if i drill down through date hierarchy from Month level to day level the data should resembled like the following:- month    day     no. of days     profit     average per day (sum of profit/no. of days) jan           1             2                 10               15 jan           2             2                 20               15 Feb         1              3                 10                10 Feb         2              3                 15                10 Feb         3              3                 15                10 unfortunately the calculated measure can be created based on the category items not the hierarchy, any suggestions on how to overcome this point.   thanks ... View more