N
ninfanger
The set up:
Our legacy database provides 30 different report types that our
clients can run from our website.
I have a spreadsheet listing every report run by customers over the
past 2 years; including unique ID#, Client name, report name, User
name, Year, Date, Time, etc.
The Pivot Table:
My pivot table is set up as follows:
- ClientName, ReportName, and Username as Row labels
- Year as Column Label
- Count of ClientName as value
- Count of ID# shown as "% of column" as another value
The pivot lists ClientName in column A, ReportName in column B,
Username in C and the count of ClientName for each report type in
Column D. With Subtotals for each ClientName.
The 2nd value described above is in column E (based on Count of ID#
and shown as % of column). This gives me the % of the grand total for
each line item.
Finally my question:
Without moving the ClientName from Row Labels to Column Labels, how
can I get a % of the Subtotal for each ReportName? I have tried
unsuccessfully to create a calculated field and my gut tells me the
answer is there. I just haven't found a workable formula.
Suggestions?
Our legacy database provides 30 different report types that our
clients can run from our website.
I have a spreadsheet listing every report run by customers over the
past 2 years; including unique ID#, Client name, report name, User
name, Year, Date, Time, etc.
The Pivot Table:
My pivot table is set up as follows:
- ClientName, ReportName, and Username as Row labels
- Year as Column Label
- Count of ClientName as value
- Count of ID# shown as "% of column" as another value
The pivot lists ClientName in column A, ReportName in column B,
Username in C and the count of ClientName for each report type in
Column D. With Subtotals for each ClientName.
The 2nd value described above is in column E (based on Count of ID#
and shown as % of column). This gives me the % of the grand total for
each line item.
Finally my question:
Without moving the ClientName from Row Labels to Column Labels, how
can I get a % of the Subtotal for each ReportName? I have tried
unsuccessfully to create a calculated field and my gut tells me the
answer is there. I just haven't found a workable formula.
Suggestions?