Log In
Register
Home
ROW function in GetPivotData
MITUL PARIKH
Member
Members
Forum Posts: 68
Member Since:
December 8, 2017
December 8, 2017
Offline1
April 21, 2018 - 11:38 pm
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.
Mynda Treacy
Admin
Forum Posts: 4515
Member Since:
July 16, 2010
July 16, 2010
Offline2
April 22, 2018 - 3:02 pm
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
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Philip Treacy, David Jernigan, Louis Muti, Hitesh Asrani
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 218
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Charles DeGraffenreaid
Cathi Giard
Sarah Young
Henry Delgado
Alita Nieuwoudt
KL KOH
Joao Marques
Regi Hampton
Taffie Elliott
Paramita Chakraborty
Forum Stats:
Groups: 3
Forums: 24
Topics: 6359
Posts: 27806
Member Stats:
Guest Posters: 49
Members: 32336
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —