Fractile(aggr()) Statement in Script

[shahafei2]

Hi all,

Can I use Fractile(aggr()) function as part of the load script?

I would like to have the following

Fractile(aggr(sum(Qty),Date),0.9)

When the sales table is grouped by the Item

The purpose is to understand the sales per item in 90% of the days in the data 

[techvarun · Accepted solution]

You can use Group by and Fractile combination 

[shahafei2]

how?

[sunny_talwar]

Provide some sample data and the output you expect to see from it within the script

[shahafei2]

Thank you I succeded to do it by using a grouped table and then resident table