I have a custom graph made of both Scatter plot and Line graph(Line graph runs in both x axis and y axis). The Problem or solution i require is for the line graph. In the line graph (for now lets only consider x axis): Line graph needs to show the average. The variables needed is already calculated using aggregate measure [i.e., (Group by)P values / (group by All)Q values = XX] So XX is the aggregated measure. Now i want to calculate a simple average(ex: 20/10 = 2, So the average should be 2) which i can use in the line graph(created in custom graph). Now when i use the - Avg(XX) in aggregated measure, i cant do that as SAS VA says i cant use an aggregated function). So i am looking for solution for this. Thanks.
... View more