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.
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