Current selections versus total

[#1]

I am currently trying to create a dimension on a cross tab which lets me easily compare the current selection to the total across all dimensions.

Basically I have two listboxes, A and B.  A user selects item 1 from A and item 2 from B.  I want a cross tab that shows sum of X and sum of Y along the rows, with the users current selections in column 1 and the sums for all selections in column 2.  Any ideas on how I might achieve this with a calculated dimension?

Thanks in advance!

[#2]

Hi mathew,

There is nothing cognos can do and qlikview can't do.

Try the attached document.

Suraj

[#3]

I am sure there is a more elegant way to do it (personally I would opt for the script change), but you can try a calculated dimension similar to the following:

=IF(MATCH(Group,GetFieldSelections(Group,','))=1,'Current','Others')

With an expressions of

=SUM({<Group=>}Value1)

=SUM({<Group=>}Value2)

I am pretty sure this won't perform well over large data sets.