Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi mathew,
There is nothing cognos can do and qlikview can't do.
Try the attached document.
Suraj
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.