Skip to Content
Former Member
Oct 18, 2010 at 05:02 PM

Running Sum on Sorted data & freeze panes?


Hi all,

Brand new to Web Intelligence XI, so learning whilst putting together first report, however need some guidance and help on the following.

I have a basic report which is sorted by highest ytd sales within the report and has breaks at each change in brand category.

I need to be able to provide a running % cumulative total for each article within each brand category based on the highest ytd sales.

I have tried using the running sum formula but this does not give correct results due to the sort, as when this is taken off

the formula is correct. Have different varients of this after reviewing the forum but unfortunately still cannot get this basic calculation to work.

My second question is that when viewing a lot of data, is it yet possible to freeze the headers in each column?

Thanks in advance for any help given.