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)
