Getting Data from PIVOT

[Illogical90]

Hello, I am using below formula in order to get the data from PIVOT but the thing is it is getting more bigger and bigger as I have to add the numbers of all the months. Can someone please suggest a smart way of doing so?

=IFERROR(SUM(GETPIVOTDATA(T(P$6),Pivot_EBTDA!$B$5,"Substream Leader (approves IL3 to IL4)",$B$42,"Business/Operational Unit",C5,"Initiative Execution Owner (Accountable)",D5,"Metric > Metric",$N$7,"Metric > Metric",$N$8,"Metric > Metric",$N$9,"Metric > Metric",$N$10,"Metric > Metric",$N$11,"Metric > Metric",$N$12,"Metric > Metric",$N$13,"Metric > Metric",$N$14,"Purpose",$K$7)+GETPIVOTDATA(T(P$7),Pivot_EBTDA!$B$5,"Substream Leader (approves IL3 to IL4)",$B$42,"Business/Operational Unit",C5,"Initiative Execution Owner (Accountable)",D5,"Metric > Metric",$N$7,"Metric > Metric",$N$8,"Metric > Metric",$N$9,"Metric > Metric",$N$10,"Metric > Metric",$N$11,"Metric > Metric",$N$12,"Metric > Metric",$N$13,"Metric > Metric",$N$14,"Purpose",$K$7)+GETPIVOTDATA(T(P$8),Pivot_EBTDA!$B$5,"Substream Leader (approves IL3 to IL4)",$B$42,"Business/Operational Unit",C5,"Initiative Execution Owner (Accountable)",D5,"Metric > Metric",$N$7,"Metric > Metric",$N$8,"Metric > Metric",$N$9,"Metric > Metric",$N$10,"Metric > Metric",$N$11,"Metric > Metric",$N$12,"Metric > Metric",$N$13,"Metric > Metric",$N$14,"Purpose",$K$7)),0)

[Richard Buttrey]

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.