Log In
Register
Home
December 8, 2017
Offline
Hello Anders; (my friend)
This is Mitul.
Good morning
How are you ?
I entered following formula in cell J122 on worksheet "DATA FOR 2017" including = to make it formula , getting error
= GETPIVOTDATA("Sum of Sales"; $I$5; "Month"; TEXT(DATE(1904;ROW(A1);1);"[$-en-GB]MMM");"Region";J$121)
Please advise me , what I am doing wrong in above formula ?
Thank you very much.
Have a great day.
Sincerely;
Mitul.
VIP
Trusted Members
December 7, 2016
Offline
Hello Mitul,
The formula you have problem with contains semicolon as separator character. That works perfectly fine for me as that is correct for my region, but not for your. Change semicolon (;) to comma (,) and you will have a working formula.
Br,
Anders
1 Guest(s)
