in pivot chart to show only top 4

[bushpalaamarnat]

hi All,,

Could any one help, like in chart table dimension limits,

Could i get first 4 or top 4 or highest 4 values in pivot chart only.

Following is the formula.

NUM(AGGR(SUM( {<KEY_FIGURE = {'$(vFigure)'}, Version = {'MCF'}>}QTY)

-

Sum ({<KEY_FIGURE = {'$(vFigure)'}, Version = {'$(=ONLY(%VersionComp))'}>}QTY),BRAND),'###,###,###.')

Regards,

Neelima

[prat1507]

Top 4 by what?? All the dimensions?

Can you please elaborate

Regards
Pratyush

[vishsaggi]

What is your Dimension here? May be try this as your calculated dimension

= AGGR( IF(Rank(

                     SUM( {<KEY_FIGURE = {'$(vFigure)'}, Version = {'MCF'}>}QTY)  -

                     Sum( {<KEY_FIGURE = {'$(vFigure)'}, Version = {'$(=ONLY(%VersionComp))'}>}QTY)

               )<5, BRAND)     

           ,BRAND)

[bushpalaamarnat]

My apologies, this is my formula in dimension.

=Dual([Profit Center TEXT],

AGGR( FABS(Sum ( {<KEY_FIGURE = {'$(vFigure)'}, Version = {'MCF'}>}QTY)      

  -    Sum ( {<KEY_FIGURE = {'$(vFigure)'}, Version = {'$(=ONLY(%VersionComp))'}>}QTY)),BRAND,[Profit Center TEXT]))

[bushpalaamarnat]

Yes, sir. I have 2 dimensions and need to limit dimension 1) to 10 and 2) to 4. In total I have 4 dimension for this char. I want to use Pivot chart over table chart, hence need advise. Kindly help.

Formulas are as below.

1) BRAND

2) this is my dimension:

=Dual([Profit Center TEXT],

AGGR( FABS(Sum ( {<KEY_FIGURE = {'$(vFigure)'}, Version = {'MCF'}>}QTY)    

-    Sum ( {<KEY_FIGURE = {'$(vFigure)'}, Version = {'$(=ONLY(%VersionComp))'}>}QTY)),

BRAND,[Profit Center TEXT]))