Forum

Notifications
Clear all

Getting error after entering below Getpivotdata formula

2 Posts
2 Users
0 Reactions
93 Views
(@mitulpar1964)
Posts: 64
Estimable Member
Topic starter
 

                       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.

        

            

   

 
Posted : 04/06/2018 6:04 am
Anders Sehlstedt
(@sehlsan)
Posts: 971
Prominent Member
 

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

 
Posted : 05/06/2018 1:42 am
Share: