I have 1 lakh of records and i need a top 5 years of dats in bar chart dynamically with out using dimension limits. Only first record contains total no of records in top of bar

[#1]

Hi can any one give me the solution for this.....

[MK_QSL]

Considering you have a date field....

Create below addition field in your script..

Year(Date) as Year

Now create a bar chart

Dimension

Calculated Dimension

IF(Aggr(Rank(SUM(Sales),4),Year)<=5, Year)

Tick Suppress When Value is Null

Expression

SUM(Sales)

[#3]

Thank u manish

[MK_QSL]

If you think this is what you was looking for, close the thread by selecting appropriate answer otherwise let me know, I can help further...

Thanks