dilawer5
Member
Is it possible to show columns in one pivot tables like Target/Achievement/Last year same month ach/%age variance/YTD target/Ytd achievement/LY Same Period Ach/Varience
Please see uploaded file link..
https://sabercathost.com/8VY7/Primary_Sales_Data_15_16.xlsx
1. Please fill formula to get YTD in Raw Source data sheet.
2. Please guide if i insert a blank sheet for helper table then how to use Offset on Pivot Tables so that my front table vlookup or match index formulas remain valid for a changing position of rows column of back end Pivot table.
https://sabercathost.com/8VY7/Primary_Sales_Data_15_16.xlsx
https://sabercathost.com/8VY7/Primary_Sales_Data_15_16.xlsx
Please see uploaded file link..
https://sabercathost.com/8VY7/Primary_Sales_Data_15_16.xlsx
1. Please fill formula to get YTD in Raw Source data sheet.
2. Please guide if i insert a blank sheet for helper table then how to use Offset on Pivot Tables so that my front table vlookup or match index formulas remain valid for a changing position of rows column of back end Pivot table.
https://sabercathost.com/8VY7/Primary_Sales_Data_15_16.xlsx
https://sabercathost.com/8VY7/Primary_Sales_Data_15_16.xlsx