Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a field called Period(DD/MM/YYYY) which is basically my Calendar Date field. There is another field called R_Period (DD/MM/YYYY) which is like past 12 months to every value in Period field. Now I need to show this in chart i.e. for every Period(Period as dimension), Sum of Quantity of only the max R_Period's month.
I have to do it using set analysis.
Please advice. PFA sample.
I tried:
(SUM({<R_Period = {"=Aggr(max(Period),Month)"}>}Retail_Qty))
also,
sum({<R_Period={'$(=max(R_Period))'}>}Retail_Qty)
also,
sum(aggr(if(rank(R_Period)=1,sum(Retail_Qty)),R_Period))
Regards,
Ruchi
Can you post expected output as well, what exactly are you trying to acheive
if you just want total for max , then your second expression will work
sum({<R_Period = {'$(=MAX(R_Period))'}>}Retail_Qty)
Hi Vineeth,
Thanks for your response.
For each Period ( Jul 2016, Aug 2016, Sep 2016, Oct 2016...) it has a set of its own 12 months data(R_Period) eg:
Jul 2016 (Period ) has (Aug 2015 to Jul 2016)(R_Period).
Expected output :
For each Period, it calculates the maximum of R_Period and sums the Quantity on it. Whereas what this expression does is, it does calculate the max of R_Period but shows only for max Period. Hence In my chart I get bar only for the max Period (Oct 2016), I want to see for all the Periods.
Please advice.
Regards,
Ruchi
Can you create an expected output table in excel, using the sample you posted for any period.