Dimension Limits Issue

[#1]

Hi All,

I Need to show Least 5 perfoming clients by Actaul Revenue. and others and totals

I should not show clients which have '0' Values in Actual Revenue or Planned Revenue

when i try to do this i get '0' Vales in Actual Revunue

But My output should look Like this

Please find attached source file (Data is in Sheet1) 

Apprecite help on this

[#2]

Hi,

Did you try to put the condition like if(YTD Planned Revenue > 0, YTD Planned Revenue) in your expression?

[Gysbert_Wassenaar]

See attached example.

[#4]

Hi Gysbert ,

Thanks for your reply ...indivudal clients seems to be correct... but 'Others' total does not seems to tie up .

Others totals should look like this

[jagan · Accepted solution]

Hi,

PFA file for solution.

Regards,

Jagan.