Hi Rania ,
The solution you are referring to has been given by Somendra Misra ; I am still working on it , and the whole subject of Pivot Tables is very confusing to me.
See the attached file , where I have created a Pivot Table , on Sheet3 , from the range :
=Data!$A$2:$G$687
There is a reason I have defined it this way.
As you can see , there are 3 calculated items , and their definitions are on Sheet4.
The calculated item NET PROFIT is not possible , since the addition of the individual item labels causes the total length to exceed the limit of 255 characters ; if you can reduce the length of the row labels or if there is another way to calculate this , even this can be done ; I will look into this later , since I am short of time at present.
What I want to explain is that the reason you are unable to create a calculated item is still not clear to me ; when the range is anywhere between :
=Data!$A$2:$G$21 ------ for January 2012
and
=Data!$A$2:$G$685 ----- one row short of the entire table
the calculated items which have been inserted are displayed correctly ; the moment I add the row 686 so that the entire table is used for the Pivot Table , the calculated item rows disappear !
Thereafter , what ever I do to modify the source data range , the same error message keeps appearing , and nothing can be done till I delete the sheet and recreate the Pivot Table once more.
Narayan
