How to display bottom 5 excluding zero.

[kavita25]

Hi,

I want to show bottom 5 in the bar chart excluding zero values.

My expression is : Total expenses/total budget *100

I found this Showing Top 5 and Bottom 5 on Bar Chart which shows bottom and top excluding zero.

But i am little bit confuse while using my logic with the given logic in the link.

Please help me with this issue..

Its urgent...

Regards,

Kavita

[kavita25]

gwassenaar‌

swuehl

mayilvahanan

stalwar1‌

Please help me with this issue...

[MayilVahanan]

HI

Can you post a sample data?

[shraddha_g]

uncheck Show Zero values at expression tab.

It might help.

[kavita25]

Yes...

PFA !

[Anonymous]

Hi,

Please check this link:

TOP 10 and Bottom 10 Customer by Revenue Amount

[kavita25]

There's no such option in expression tab

[shraddha_g]

Check at Presentation Tab, Suppress Zero-Values option

[kavita25]

Can u pls check the sample data...

I already checkd those options

[antoniotiman]

Hi,

may be

If(Rank((sum({<LinkDate={'>=$(vCalMinDate)<=$(vCalCurrentDate)'},Txn_Type={'RnR'}>}TotalExpense)/
sum({<LinkDate={'>=$(vCalMinDate)<=$(vCalCurrentDate)'},Txn_Type={'RnR'}>}[Op.Bal]))) <= 5,
(sum({<LinkDate={'>=$(vCalMinDate)<=$(vCalCurrentDate)'},Txn_Type={'RnR'}>}TotalExpense)/
sum({<LinkDate={'>=$(vCalMinDate)<=$(vCalCurrentDate)'},Txn_Type={'RnR'}>}[Op.Bal])))