Hi,
I have data arranged as in A1:F11 and would like to be able to summarise the results calculated in C14:F17 by using a Pivot Table rather than formulae.
Is it possible to achieve this with a Pivot Table?
If so could someone kindly please show me how.
Thanks!
Book1ABCDEF1SECURITYASSET...