Is it possible to calculate the total cost for all sites within a pivot table. With help from people on this forum I have managed to create the pivot table that I want and been given the formula so that I can find the cost for each site, where it only counts each suite once - excellent!
But it would be useful if I could find the sum of all the sites, but I don't know how to do this or even if it is possilbe.
The spreadsheet is attached.
Bookmarks