Rearranging of rows in Matrix table

[harirao]

Hi All,

Can you pls assist me is it possible to rearrange the rows ASC to DES order, keeping WW in Top of the matrix table row.


Below mentioned calculate measures used for table.

> 6 Weeks Visibility # Deal / % of Regional Total = CONCATENATE(Query1[%6week_3], CONCATENATE("/",FORMAT(Query1[% 6+ weeks visibility],"0%")))

%6week_3 = IF(ISBLANK(CALCULATE(DISTINCTCOUNT(Query1[NxOpportunityIdentifier]), FILTER(Query1, Query1[actual_visibility_weeks]>=6))),0,

CALCULATE(DISTINCTCOUNT(Query1[NxOpportunityIdentifier]), FILTER(Query1, Query1[actual_visibility_weeks]>=6)))

% 6+ weeks visibility = IF(ISBLANK(DIVIDE(Query1[%6week_3],Query1[%6week_1&2])),0,

DIVIDE(Query1[%6week_3],Query1[%6week_1&2]))

Thank you

Regards,
Hari

[v-alq-msft]

Hi, @harirao 

You may try to make the matrix visual selected, click 'Sort by'=>'Region', make 'Sort descending' selected.

You can also try what is suggested by @lbendlin . You may rename the 'Total' as 'WW'.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

is WW its own region, or is it just a summary of the other regions?  If the latter then you should not show it in the same hierarchy level - this is confusing to users.  

Just use regular matrix functions and rename "Total" to "WW".

[harirao]

Hi,
Yes WW is Summary of all region, specifically requested  that WW should be on Top remaining Geo in DSC to ASC order.
Thank you

Regards,
Hari