Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
87
Views
Topic starter
Hello Mynda;
Good Morning;
This is Mitul.
I am having difficulty getting correct answer in GetPivotData with Row function
Thank you for your help.
Sincerely;
Mitul.
Posted : 22/04/2018 9:38 am
Hi Mitul,
Try this:
=GETPIVOTDATA("Value",$G$1,"MONTH",TEXT(DATE(1904,ROW(A1),1),"mmmm"),"Year","2016")
You have to give the text function a date to convert to the month name. It doesn't matter what the year or day values are, which is why I've used 1904 and 1, because these are discarded when TEXT converts the date to the month name.
Mynda
Posted : 23/04/2018 1:02 am
