Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Top 4 by what?? All the dimensions?
Can you please elaborate
Regards
Pratyush
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)
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]))
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]))