10 Replies Latest reply: Oct 3, 2016 1:41 PM by john cena

# When i select a month previous 3 months data should be shown

Hi my data is like this

Month            products

Dec 2015         10

Nov 2015           3

Oct 2015             1

Sep 2015           3

Aug 2015           6

Jun   2015         15

My requirement is when i select a month say Dec 2015, dec2015 data + the previous 3 months data sholud appear. If i selected oct 2015 i want oct2015 and previous 3 months data

Regards

Jhon

• ###### Re: When i select a month previous 3 months data should be shown

Use set analysis to do this. May be like this:

Count({<Month = {"\$(='>=' & Date(AddMonths(Max(Month), -3), 'MMM YYYY') & '<=' & Date(AddMonths(Max(Month), 0), 'MMM YYYY'))"}>} products)

• ###### Re: When i select a month previous 3 months data should be shown

Hi Sunny i have a straight table like this

Month  sum of products   count of x  %of y

And i have a list box month were all the months are present and when i click on a particular month the last 3 months data should come and should i write the same expression every where in other expressions also

• ###### Re: When i select a month previous 3 months data should be shown

Try this then

Count({<Month>} products) * Avg({<Month = {"\$(='>=' & Date(AddMonths(Max(Month), -3), 'MMM YYYY') & '<=' &Date(AddMonths(Max(Month), 0), 'MMM YYYY'))"}>} 1)

• ###### Re: When i select a month previous 3 months data should be shown

Thank you so much sunny

• ###### Re: When i select a month previous 3 months data should be shown

In June the top two profitted cuntries are Argentina and Japan

In May the top two profitted cuntries are America and Argentina

What i want is when i click on jun i want both june and may data to dispaly and the comparision should be between the selected month (jun) and top two values of it  Argentina and Japan to Argentina and Japanin May

• ###### Re: When i select a month previous 3 months data should be shown

Is this a new requirement or we still trying to fix the old one? If it is new, I would suggest starting a new thread to address this issue

• ###### Re: When i select a month previous 3 months data should be shown

Hi Sunny this is a new requirement unfortunately the link is not moderator approved, i tried to create around 5 to 6 threads but no luck.