locked
Getpivot data formula RRS feed

  • Question

  • Hi..

    Could you please assist to make copy for GetPivot data formula for the whole column or some selected rows.

    The formula was ..

    =GETPIVOTDATA("[Measures].[Sum of QTY 2]",$M$2,"[Table35].[DATE]","[Table35].[DATE].&[2020-07-01T00:00:00]","[Table35].[LOCATION]","[Table35].[LOCATION].&[AUH]")

    I got the result for first cell only but it was not possible to make copy for some selected cells.

    Thanks,

    Friday, July 17, 2020 6:14 PM

All replies

  • Hi Hannan81,

    Could you please share us any screenshots related to the pivot table and incorrectly returned values? When there is sensitive information, please cover it.

    We should ensure the pivot table is continuous and non-broken.

    (Please note, new users in this forum needs to confirm accounts by replying in the thread below, then they can upload images after the confirmation.

    Verify Accounts 43)

    Besides, what does "make copy for some selected cells" mean?

    Does the formula does not work when it copied to other cells? Or do you have other explanation?

    Looking forward to your reply.

    -----------------------------------------------------------------------------------------------------------------------

    This "Excel IT Pro Discussions” Forum will be migrating to a new home on Microsoft Q&A, please refer to this sticky post for more details.

    Regards,

    Emily


    "Office" forums will be migrating to a new home on Microsoft Q&A !
    We invite you to post new questions in the "Office" forums' new home on Microsoft Q&A !

    Monday, July 20, 2020 3:05 AM
  • Hi Hannan81,

    Is there any update?

    Regards,

    Emily


    "Office" forums will be migrating to a new home on Microsoft Q&A !
    We invite you to post new questions in the "Office" forums' new home on Microsoft Q&A !
    Friday, July 24, 2020 9:54 AM