what if we use another much more simple way to get the same result
in
Data Analysis with Excel Pivot Tables
/
GetPivotData is great! Extracting data from the Master Pivot Table
what if
we can make a small pivot table containing years (rows) and a sum of all that we need in (sum value) we will get a smaller pivot and more flexible and easy to be in the same screen with the desired report and we can directly get the values from with equal sign with no difficulties and ref errors.
smaller, faster, and same efficiency check the attached pic plz.
thanks.
0 answers ( 0 marked as helpful)