1 Reply Latest reply: Apr 12, 2018 10:26 AM by German Venezia RSS

    Pivot table dimension calculation

    Wanyun Yang

      Hi guys,

       

      In my qlik sense pivot table, I got two rows:

      Capture.PNG

      The second row should be sales_amount/goal. So I put my function as: SUM(Amount)/Goal. The expression shows OK, but after applied, it becomes invalid dimension:

      Capture.PNG

      Is it because can't do calculation with dimension? What should I do if I still need to put Goal% into dimension?

       

      Thanks in advance!