• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot

B

bpnmurthy

New Member
In a pivot table, data's are available for month wise, below of the pivot, totaled for the respective one month for ex: - ( =GETPIVOTDATA("Sum of 17.02.12",$C$3,"shore indicator1","ONSHORE") in the next cell, need to copy the same formula but the date should get change as per the date available in the pivot.

Help me to get the date change.
 
If you're wanting the formula reference to shift like that, and you aren't using another cell as a reference point, e.g.

=GETPIVOTDATA("Sum of "&TEXT(AA1,"dd.mm.yy"),$C$3,"shore indicator1","ONSHORE")


Then you should skip the GETPIVOTDATA function and just use a regular cell reference:

=B10
 
You must log in or register to reply here.
Back
Top