YTD Actual Sum
Total
The pivot table which I have created contains 2 rows, 0 columns, and 1 set of data values. The YTD Actuls are in the data pivot table layout.
Currently, when the pivot table is created, the 2 pivot table designated rows are lined up in the same excel row, and the...
Hi,
I am trying to do a sort of values in descending order. Every time I highlight the pivot table and try to sort the Total actuals (amount), it would not allow me to do it. When I refresh, it automatically sorts it out for me by the name list, in alphabetical order! Thanks!
Hi,
Would you know how to copy the subtotal amounts, without copying the details associated with it to another worksheet? Everytime I highlight the sells and copy, it copies EVERYTHING, when all I want is to copy the subtotals. Thanks!!!
Cindy
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.