Pivot Table design problems (% of grand total etc)

[broro183]

hi all,

This is cross posted as
http://www.excelforum.com/excel-general/666284-pivot-table-design-problems-of-grand-total-etc.html

I posted this at the above site yesterday & have had a number of views but
no replies as yet.

In the other post, I have attached a file containing 3 questions about
specific Pivot Table design problems (in Excel 2003). Can you please have a
look at the file & let me know if it is possible to create Pivot tables in
the same way as the "normal" calculation tables that are also included?

The questions are contained within the file & linked to the appropriate area
which will hopefully make it clearer due to the context. I could never make
the problem as specific when just typing into a message but here's a rough
outline...

Q1 is roughly: %age showing row as a proportion of grand total.
(I have seen some posts that suggest this is not possible. Do I need to
include a new column in the PT's source data?)
Q2: sub total of 2 data fields with more columns to the right.
Q3: can the various data/formats be shown in a single PT?
(If not, which I think is likely to be the case, I'll just link them to the
specific PT's on the previous sheet)

The main aim of my use of PT's in this file is to minimise the manual
updating/copying & pasting that is currently done by the current spreadsheet
creator.

Thanks in advance,
Rob

__________________
Rob Brockett
NZ
Always learning & the best way to learn is to experience...

 

[broro183]

Thanks Smartin,

I think your suggestions will do everything - I'll check all this out when I
get back into the office tomorrow - it makes sense & I don't know why I
hadn't considered the "getpivotdata" option (one track mind! & maybe
subconsciously beacuse I have been frustrated by the inflexible setup of the
formula when it converts/makes the references into strings - but for this
purpose (design once & use repeatedly) it should be ideal).

I'll be in touch if I have any problems...

Thanks
Rob
__________________
Rob Brockett
NZ
Always learning & the best way to learn is to experience...