David,
I have the following repeat control formula working against a categorized view so that it only returns the category values and the total I want.
The view is categorized view by year/month with totals for the month.
The formula is
var colIndVal = viewEntries.getNavigatorPosition();
if(@Length(colIndVal)==1){
var colVal = viewEntries.getColumnValue("$9");
return colVal + "<br />";
} else if(@Length(colIndVal)==3) {
var colVal = viewEntries.getColumnValue("CatMonth");
var colVal2 = viewEntries.getColumnValue("Total");
return colVal + "-" +colVal2 + "<br />";
} else {
}
And the output is:
2009
February-192.78947368421052
March-139.53846153846155
April-124.18518518518519
May-117.55172413793103
June-111.38095238095238
July-113.05
August-119.71428571428571
September-107.46153846153847
October-115.15789473684211
2010
January-114.25
February-113.53333333333333
So based upon the level of category it will return the result from the view for each category but return no values for the detail rows. The formula would have to be adjusted for how many category columns you had (in this example I have two)
I haven't tried it yet but I believe I can stick this inside my dynamic table solution to produce a table so that the values are separated into columns for display purposes.
I will try that next but I think this should work for you.
I will work on the table solution and let you know.