9 Replies Latest reply: May 17, 2012 1:23 PM by groizner RSS

    Calculated Dimension

    Julie Stephens

      I have a table of Vendors (e.g., Apple, HP, Dell, Sony) and I would like to compare results from 1 selected vendor to the result of everyone else. For example, let's say that my selected Vendor is 'Dell':

      Vendor Sales (ThisYr) Sales (LastYr)
      Dell $100,000 $125,000
      Others $500,000 $550,000

      Can I use a calculated Dimension for this, where 'others' would represent an aggregated total of non-selected vendors?