Showing totals for Others

[mparker123]

Hello All,

I am building a bar chart which as 2 Dimensions "Month" and "Prj_Desc" and 1 expression for "HOURS"

(Sum({<PRJ_DESC={"=Rank(Sum( HOURS))<=20"}>}HOURS).

The expression works I just want to add to it. What I want to add is a "Others Total Field". Within this field I want it to sum the remaining projects that are not in the top 20. How would I add this to my expression

Because I have 2 Dimensions I am unable to use the Dimension Limits  when I check "Show Only" top 20 and check the "Show Others" option nothing happens. So I used the set analysis above to show me just the top 20 but I still want to show the other projects but in one field called "Others Total Field"

[zhadrakas]

what about another expression like this:

(Sum({<PRJ_DESC={"=Rank(Sum( HOURS))>20"}>}HOURS).

[Anonymous]

you can use dimension limits for this to show top 20 by expression rank(sum(hours)) and others bar will show the total cumulative of others which are not in top 20.

[mparker123]

Where can you show top 20 by expression?

[Anonymous]

Please look at the below snapshot.

[Anonymous]