2 Replies Latest reply: Dec 4, 2017 4:39 AM by Teis thrane Wamsler RSS

    Pivot Table with Dimensions and Measures and Inline

    Mrudul K

      Hi All,

       

      We have a Pivot table like -

      Product Analysis.png

      We have another similar table, which looks like -

      Product Analysis_1.png

      Now in first image, Product is a Dimension whereas, M1, M2, M3 are calculated measures.

      In second table, we have Measure M1, M2, M3 as Inline load, and using pick match function we are calculating Avg, Sum and Diff.

      Any idea regarding, how we can combine both the tables.

       

      Regards,

      MK