0 Replies Latest reply: Feb 15, 2018 11:57 AM by CTS Lumesse RSS

    Pivot table with more dimensions

    CTS Lumesse

      Hi,

      the thing I'm working on is that pivot table should have data split by month. So I need to count different values from different sources and have them in one table, filtered by month, but every data source has own "date" field.
      Please find attached screenshot where my pivot table doesn't work properly, and below 2 simple tables with proper data in it. I think that "Columns" section needs to be rebuilt but I don't know how.

      The thing is that I need data from these 2 simple tables in 1 pivot table. Is it possible, if yes - how?

      qlik2.PNG