Powerpivot Pivot Table Not "footing" / Summing down RRS feed

  • Question

  • I am currently using powerpivot with a mapping relationship and when I pull in the SKU "mapping", my subtotals are correct but the data above them isn't adding down / footing to the correct amount. 

    I think what is happening is I don't have all my SKU's mapped. However, usually when this is the case I have a (blank) row which I don't have currently. 

    Any help / advice is appreciated! Are my settings maybe incorrect? 


    Monday, August 5, 2019 8:36 PM