order by Sort -dimensional reporting

[cognos05]

Hi,
                                    Jan   Feb Mar  Total
Rep A    Account 1        12    13   13     38   
             Account2         45     15    15    75
             
RepB     Account 1        12    13   14     39   
             Account2         45     15   15    75
           
This is how my cross tab looks.

The expression on Account Data item is  order(filter(Accounts,(lastMonth=0)),[Total],BDESC)
I am filtering certain accounts which doesnt have last month sales and the odering it descending by total.

Now this all works fine but the ordering of reps is not done.., because only the accounts are ordered.

My Rep data item had the expression

Order(reps,(aggregate(currentMeasure within set[Months],Desc)

Which means bring me the reps in descending order with whom having higher sales for the months.

The reps doesnt take the filtered accounts in to consideration while aggregating. IS there a way to make reps consider the filtered accounts and then order them.

So its like the rep has to be sorted based on it childrens total sale value,but there is a filter on its children which says bring children whoselast month sale is zero.

Please let me know if I am not clear.

Thanks,
Nithya

[rockytopmark]

replace: set [month]
with: set [Account]           <--- your filtered and ordered account data item

Order(reps,(aggregate(currentMeasure within set [Account],Desc)

[cognos05]

I had tried that already and I am getting the same results. Should I set some solve order for the reps data item.

[cognos05]

Ideally order(reps (aggregate (currentMeasue within set  [Accounts]),Desc) - will this do a a aggregate only on the accounts under each rep.
I am still getting some random order on rep.
Any suggestions are appreciated.

Thanks,
Nithya

[cognos05]

Guys any suggestions on this.

aggregate(currentMeasure within set [Accounts]) is not sorting my reps based on the total of measure with respect to the accounts with in them (Filtered Accounts)