08-22-2014 05:34 AM
I have a fact table which contains historical sales data.
I create monthly average of sales by aggregated measure.
I also want to create a quarter average or percentile on the same time series plot with the same dimension .
For example, I calculate a monthly average of Nov 2013, I also want to have a 95 percentile of the data between Sep~Nov 2013 on the same plot.
How to create the aggregated measure and time series plot?