Hi all,
In the aggregate function list, we have 'Median'(along with Total, Min.MAx.etc...) as one of the options. But when I use this it does not work. No effect is seen. Even the query generated does not involve any function which would calculate the median.
But in Oracle we can acheive the median value using the following query...
SELECT A.DEPT,A.SALARY, percentile_disc (0.5)
within GROUP (ORDER BY A.SALARY) AS "Median"
FROM Test_Table BY A.DEPT,A.SALARY
Can we bring out the funtionality of this query in Report Studio. Can we some how bring the 'WITHIN' clause as part of the query generated by Report Studio?
Is there a way other than using Tabular SQL?
Thanks in advance for any pointers...
Ramesh
In the aggregate function list, we have 'Median'(along with Total, Min.MAx.etc...) as one of the options. But when I use this it does not work. No effect is seen. Even the query generated does not involve any function which would calculate the median.
But in Oracle we can acheive the median value using the following query...
SELECT A.DEPT,A.SALARY, percentile_disc (0.5)
within GROUP (ORDER BY A.SALARY) AS "Median"
FROM Test_Table BY A.DEPT,A.SALARY
Can we bring out the funtionality of this query in Report Studio. Can we some how bring the 'WITHIN' clause as part of the query generated by Report Studio?
Is there a way other than using Tabular SQL?
Thanks in advance for any pointers...
Ramesh