6 Replies Latest reply: Jan 13, 2016 8:16 AM by Giampiero Cina RSS

    Get dim values from a pivot table and exclude those values in another straight table dimension

    Giampiero Cina

      Hi guru's,

      I've a problem.

      I have a pivot table that shows the sold articles per shop in a specific period.

       

      Pivot Table:

       

      Dim1 : Shop

      Dim2 : Cod Art

      Expr1 : Sum(qta)

      Expr2 : Sum(Sales)

       

      Those dimensions are referred to a table with stock movements.

       

      I have to show in another table all the articles (cod Art) unsold in that specific period.

      So all the Cod Art that comes out from the pivot table must be excluded from the whole set of Articles.

       

      To take those unsold articles i have to refer to the Articles tab.

       


      I hope it's clear

      Any idea about it?

       

       

      Thanks in advance

      Best regards