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.