Forum

Notifications
Clear all

Need help again with Getpivotdata formula

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

     Hello Friend;

        Good Morning

       This is Mitul.

    In  file attached ,  I like to learn  correct GetPivotData formula (like to see total amount for Jan. 2016, Feb. 2016, Mar. 2016, etc.) .  Also, Please  enter on the worksheet , what values needs to be entered in each field?

    Thank you very much.

   Have a great day.

  

 
Posted : 30/04/2018 11:00 am
(@fravis)
Posts: 337
Reputable Member
 

Hope I understood your question well.

See attached file with the solution and in red my explanation.

I put the solution in place and not as text, because of localized issues. When you open you see your right solution.

Frans

 
Posted : 30/04/2018 1:56 pm
(@mitulpar1964)
Posts: 64
Estimable Member
Topic starter
 

             Hello Frans;

                        This is Mitul.

                 Thank you very much for providing me correct  GPD formula.

 
Posted : 30/04/2018 5:10 pm
Share: