Mohammed Hafeez
New Member
Hello Everyone,
It is great being here, i got to learn so many things. One of my quick question is; i am trying to create a pivot table which shows YTD Values with % variance in pivot it self. It goes something like this:
Sheet 1 : This will have all the data for past several years already entered, for this year i will keep on updating the data on a daily basis with columns such as date, sales, shop code, name, etc...(Refer attached excel file)
Pivot Sheet: Here is where the real thing happening, all the data gets pulled here in a formatted manner, the way i need.
The Problem: The problem i am facing is, I am unable to see Year till date report with variance to be pulled from Sheet 1. i want excel to pull data from previous years till current date. For example. if i select Jan, Feb & April in the month slicer then i want pivot to display performance from jan till aprils current or todays date of previous years. which is not happening.
I hope it is not quite confusing.
It is great being here, i got to learn so many things. One of my quick question is; i am trying to create a pivot table which shows YTD Values with % variance in pivot it self. It goes something like this:
Sheet 1 : This will have all the data for past several years already entered, for this year i will keep on updating the data on a daily basis with columns such as date, sales, shop code, name, etc...(Refer attached excel file)
Pivot Sheet: Here is where the real thing happening, all the data gets pulled here in a formatted manner, the way i need.
The Problem: The problem i am facing is, I am unable to see Year till date report with variance to be pulled from Sheet 1. i want excel to pull data from previous years till current date. For example. if i select Jan, Feb & April in the month slicer then i want pivot to display performance from jan till aprils current or todays date of previous years. which is not happening.
I hope it is not quite confusing.