Share via

Microsoft excel

Anonymous
2024-11-20T14:54:52+00:00

Hi anyone can help me on this

I have a set of data(i append two excel file using power query)thus my data will be in pivot table. Usual practice, i will copy from pivot table to my excel template as per info required. May i ask on what formula can i use to auto calculate from the picot table so i dont need to copy n paste into excel template

Thanks

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-11-20T16:57:42+00:00

    hi, may i ask how to insert file here?

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-11-20T15:27:53+00:00

    Hi,

    The most likely function you would use is GETPIVOTDATA. However, we would need to see a sample to be sure of the best solution.

    Hope this gets you started,

    Was this answer helpful?

    0 comments