0 Replies Latest reply: Aug 15, 2016 2:17 PM by SRIKANTH P RSS

    Currency converssions

    SRIKANTH P

      hi all please give me a solution for below query

      In Qlik sense,

      i have a pivot table with geographical wise Monthly Target sales and actual saleS,

       

      Question: I want to create YTD to display all months target sales sum and all months actual sales sum and I want to find what is the percentage of total actual sales sum in target sales sum.PLEASE GO THROUGH THE BELOW TABLE

      Header 1Header 2Header 3Header 4Header 5Header 6Header 7Header 8Header 9Header 10
      GeographyAPRL-2016APRL-2016MAY-2016MAY-2016JUN-2016JUN-2016YTDYTDPER(%)
      TAR_SALEAC_SALETAR_SALEAC_SALETAR_SALEAC_SALETAR_SALEAC_SALE
      US100080012001400160014003800360094.73

      MY DIMENSSION IS :GEOGRAPHY

      MEASURE :SUM(AMOUNT_INR.)

       

      COLUMN S ARE :MONTH_NAME  AND SALES_TYPE(TAR_SALES, AC_SALES)