dramnath1981
Member
Hi Chandoo,
I have a peculiar problem. I want to show some data points which are for the previous months (not a part of the Current month’s Survey file) along with the current month Pivot table. I need to have Previous months data against respective Parameters in order to show the last month’s performance.
Is there any way to define some stangnent data points in a Pivot Table, which will not change? I am describing this as problem because, not all the Parameters will have values all the months. So, if some of them are missing, the total table will be collapsed as it has some external data which Excel cannot understand and arrange accordingly.
Regards,
Ramnath
I have a peculiar problem. I want to show some data points which are for the previous months (not a part of the Current month’s Survey file) along with the current month Pivot table. I need to have Previous months data against respective Parameters in order to show the last month’s performance.
Is there any way to define some stangnent data points in a Pivot Table, which will not change? I am describing this as problem because, not all the Parameters will have values all the months. So, if some of them are missing, the total table will be collapsed as it has some external data which Excel cannot understand and arrange accordingly.
Regards,
Ramnath