Combo chart help required??

[rohitians]

Hello,

I have a combo chart where in net sales division wise is displayed ....i want to display top 5 division sales contribution to total sales in a text box...

Following is the expression for sales...

(SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},

[Posting Date]={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}>}[Gross Sales Amount])

-

SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},

[Posting Date]={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}>}[Sales Return Amount])

)

/100000

Thanks and Regards,

Rohit Yadav

Message was edited by: Rohit Yadav

[kaushiknsolanki]

Hi,

     Kindly send the qvw file.

Regards,

Kaushik Solanki

[kaushalview]

Hi,

If you want to dispaly top 5 division sales then use rank function with aggr of based on Field u want to sort.

Regards

Kaushal Mehta

[rohitians]

No i want is percentage of sum of sales of top 5 divisions contribution to the total sales of company...

[rohitians]

Hey do want to say in this manner,

=AGGR(IF(RANK((SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},

[Posting Date]={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}>}[Gross Sales Amount])

-

SUM({$<FinancialYear=,FiscalYear={$(=max(FiscalYear))},

[Posting Date]={">=$(=YearStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]),0,4))<=$(=max({$<FiscalYear={$(=max(FiscalYear))}>}[Posting Date]))"}>}[Sales Return Amount])

)

/100000)<=5,Division)  

[Anonymous · Accepted solution]

HI ,

Please find attached qvw.

[rohitians]

Thank You Jatin..