Hi,
i have simple formula in table like here:
Screenshot_15.png
I would like to build pivot table which will be calculating (Disk Size + Disk Capacity) for row 1, (Disk Size + Disk Capacity) for row 2, and multiply by Servers value = 2. And have total for each Item.
So whole formula is (Disk Size + Disk Capacity) + (Disk Size + Disk Capacity) * Servers Value.
How can i do this using pivot table?
Best,
Jacek
Bookmarks