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
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.
0 answers ( 0 marked as helpful)
Submit an answer
Resolved: there is no final exam to attend in order to get the certificate for this course
Hi, why i get error on Gross Sale Income formula? i can't figure it out. hope someone will give ans.
How does your data get immediately formated as soon as you paste the formula into other cells