How to consider only Maximum month data in all years in bar chart , here Year as Dimension

[#1]

Hello All,

I have taken Dimension as Year and Expression as Sum(sales). Here i have to consider Maximum month data in all years in bar chart like attached image.

Ex: 2015 => December data

     2016 ==> December Data 

     2017 ==> July Data   only

[el_aprendiz111]

Hi,

1 exam

Aggr(IF(Rank(SUM(sales))= 1, SUM(sales)),year,month)

[MarcoWedel]

Hi,

one solution could be also:

Max(Aggr(Sum(Sales),MonthYear))

table1:
LOAD *,
    Year(MonthYear) as Year;
LOAD RecNo() as ID,
    MonthName(MakeDate(2015),Floor(Rand()*36)) as MonthYear,
    Ceil(Rand()*100) as Sales
AutoGenerate 100;

hope this helps

regards

Marco

[effinty2112]

Hello,

Maybe:

Max(Aggr(Sum(Sales),Month,Year))

Cheers

Andrew

[passionate · Accepted solution]

Hi Tulasiram,

Create a master calendar with (Year, Month, MonthNo, etc)

MonthNo is month number i.e 6: Jun; 7: Jul

Dimension:

Year

Use below set Analysis in expression:

=Sum({<Year,MonthNo={'$(=Max(MonthNo))'},Quarter,week,Date>}Sales)

Regards,

Pankaj