22 Replies Latest reply: Sep 23, 2011 5:37 AM by Joe Kirwan RSS

    Pivot Table - Include Table 1 Dimensions for Table 2 aggregation even if not present in Table 2

    Joe Kirwan

      I have ITEMS table with Dimensions CODE and ITEMCODE. I have a SALES table with TRANSDATE, TRANSMTH,TRANSREF, ITEMCODE and LINEVAL.

       

      I have built a Pivot Table which shows total LINEVALUE for CODE per TRANMTH.

       

      But, I want to show for all CODE, even for CODE where there is no record in the SALES table.

       

      Currently in my Pivot Table, only displays CODE where there is a record in the SALES table.

       

      As far as I can tell, I have unchecked the relevant Suppress Zero and Suppres Null.

       

      Help anyone?