Traditional web-based reporting with SAS BI tools

Web Report Studio - Percentile

Reply
N/A
Posts: 0

Web Report Studio - Percentile

Hi, I need to create a percentile function in Web Report Studio that work with rows of 1 column, but I found only PCTL function that work with more column of 1 row.
For example: I have 1 table on Oracle with 1 column "Measure" and 1 dimension "Region", I need to know the percentile 25° of all row of column "Measure".
I tried with PCTL function, but the result is all rows of table !

Can any one help me?
Post a Question
Discussion Stats
  • 0 replies
  • 113 views
  • 0 likes
  • 1 in conversation