1 Reply Latest reply: Nov 19, 2010 9:44 PM by John Witherspoon RSS

    Override dimension in Pivot table

      Hi Everyone,

      I have something like this in the Pivot table I have attached (Excel).


      I want the Column 1 to be independent of Company (A,B,C) which is one of the dimension in pivot table. I tried Set analysis, but still the Company dimension is applied to Column 1.

      FYI, Column 1 is the sum of YTD Sales for the Items.

      Is there something that I am missing,in terms of Set Analysis, or any other way to make the Column1 to be independent of the Companies in the pivot table.