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 1 | Header 2 | Header 3 | Header 4 | Header 5 | Header 6 | Header 7 | Header 8 | Header 9 | Header 10 |
---|
Geography | APRL-2016 | APRL-2016 | MAY-2016 | MAY-2016 | JUN-2016 | JUN-2016 | YTD | YTD | PER(%) |
| TAR_SALE | AC_SALE | TAR_SALE | AC_SALE | TAR_SALE | AC_SALE | TAR_SALE | AC_SALE | |
US | 1000 | 800 | 1200 | 1400 | 1600 | 1400 | 3800 | 3600 | 94.73 |
MY DIMENSSION IS :GEOGRAPHY
MEASURE :SUM(AMOUNT_INR.)
COLUMN S ARE :MONTH_NAME AND SALES_TYPE(TAR_SALES, AC_SALES)