Just started using BOXI Rich Client and am in need of some help. I am using excel as my datasource and am trying to sort a table that was populated by a number of dimensions. There are entries for each month and what I want to be able to do is get the sum total for each dimension, and then sort from the highest sum to the lowest. I am able to get the sum using the sum function but I am not able to sort by that result.
While I am sure the fix is pretty straight forward, numerous searches have not been able to help me get this sorted. If anyone can help it will be greatly appreciated. Screenshot of the table is attached.
I had a look at the ranking function but could not see how it could be applied to the table. But I can’t see what dimension I would enter into the “Based on” entry. If I had a variable that was the totals for each dimension, I could rank by that. But when I use the sum function it does not give me the option to use SUM to sort by.
Not completely clear from your example, to be honest.
Well, create one, you may have to extend the calculation context to evaluate the sum for each dimension value. You may have to use a Rank function rather than the menu bar method.
This is the only way that I think you will be able to solve this.
I have been trying to create a variable to sum the dimensions, but can’t seem to get that working. If you look at the table you will see all the dimensions from 2-36. I dont understand what you mean by “Extend the calculation context to evaluate the sum for each dimension value”
I can use the rank function alright, but need to get this variable (Total Sum) to rank by.[/quote]
Your “aggregate” isn’t based on a dimension object, is it? Since you imported an excel document, can you change the type of the column (in the data manager) to be a measure, with the aggregate projection set to “sum”?
If it is a dimension, then the left to right sort is probably taking precedence.
(BOB member since 2010-04-14)
(BOB member since 2005-01-06)
(BOB member since 2010-04-14)
(BOB member since 2005-01-06)
(BOB member since 2002-08-15)