Bottom problem in table

[fkeuroglian]

Hi expert

I have a problem, i create bottom table pivot but when i try to show, only put the TOP instead the bottom

i want the bottom 10 and show the top 10

what could be?

thank you a lot

attached the example

[Anonymous]

Sorry... I could not understand your problem. Please could you explain again?

[jagan · Accepted solution]

Hi,

Try like this for Bottom 10, you have [Nombre Asesor] with zero values, to overcome this I have added this in expression [> 30]={'>0'}.

Dimension: [Nombre Asesor]

Expression:

If(aggr(if(

rank(-(SUM({<BanderaBanca={'0'}, [> 30]={'>0'} >} [> 30])

- SUM({<BanderaBanca={'0'},BanderaVenta={'0'},Año={$(vPriorYear)},Mes={$(vPriorMonth)}, [> 30]={'>0'}>} [> 30])))<=10,1),[Nombre Asesor]),

(SUM({<BanderaBanca={'0'}, [> 30]={'>0'}>} [> 30])

- SUM({<BanderaBanca={'0'},BanderaVenta={'0'},Año={$(vPriorYear)},Mes={$(vPriorMonth)}, [> 30]={'>0'}>} [> 30]) ))

Hope this helps you.

Regards,

Jagan.

[fkeuroglian]

Excellent Jagan, Thank you a lot

what is the difference that the value has zero ? what change?

Fernando

[fkeuroglian]

Jagan, how be with this expression?

If(aggr(if(

rank(-(SUM({<BanderaBanca={'0'}, [> 30]={'>0'} >} [> 30])

- SUM({<BanderaBanca={'0'},BanderaVenta={'0'},Año={$(vPriorYear)},Mes={$(vPriorMonth)}, [> 30]={'>0'}>} [> 30])))<=10,1),[Nombre Asesor]),

(SUM({<BanderaBanca={'0'}, [> 30]={'>0'}>} [> 30])

- SUM({<BanderaBanca={'0'},BanderaVenta={'0'},Año={$(vPriorYear)},Mes={$(vPriorMonth)}, [> 30]={'>0'}>} [> 30]) ))

thank you a lot Jagan, very useful and helpful

[jagan]

Hi Fernando,

You dimension has many 0 values, the bottom 10 are all zeros and zeroes are automatically supressing in the chart.  If you want to view this you can uncheck Supress zero values option in Presentation tab.

Regards,

Jagan.