11 Replies Latest reply: Apr 8, 2014 5:45 PM by Clark Kipling RSS

    Current selections versus total

      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!