3 Replies Latest reply: May 10, 2013 11:15 AM by Adam Haithcox RSS

    No partial sums with dimension selections

    Adam Haithcox

      I feel that this is a configuration problem, but I can't find another relevant discussion on this. I have a pivot table that without a selection in all dimension will not show partial sums. But if I have a selection in each dimension, the partial sums show.

       

      With Territory and Catalog Section selected, but without Ship To Acct. selected:

       

      Capture1.PNG

       

      With all selected:

       

      Capture.PNG

       

      The same holds true if I deselect and select Catalog Section.

       

      What am I missing?

       

      UPDATE:

       

      I've narrowed it down to the comparison operator in my expression. If I change my expression from:

       

      =if (Sum({<[Fiscal Year]={'>=$(=FiscalCurrentYear-2)<$(FiscalCurrentYear)'}, [Customer Sub Type]={'ENT-Human'}>} [Sales Amount]) <= 0,

                Sum({<[Fiscal Year]={'$(FiscalCurrentYear)'},[Customer Sub Type]={'ENT-Human'}>}[Sales Amount]))

       

      To:

       

      =if (Sum({<[Fiscal Year]={'>=$(=FiscalCurrentYear-2)<$(FiscalCurrentYear)'}, [Customer Sub Type]={'ENT-Human'}>} [Sales Amount]),

                Sum({<[Fiscal Year]={'$(FiscalCurrentYear)'},[Customer Sub Type]={'ENT-Human'}>}[Sales Amount]))

       

      ...I get my partial sums. Product is wrong; but I get my sums. Anybody?