Hello....
I have 3 pivot tables all from the same source data. Pivot Table 1 shows all "occurrences". Pivot Table 2 is a subset of all "occurrences" that also have some specific "codes". Pivot Table 3 is a subset of Table 2 that counts only some of the "codes" listed in Table 2.
I'd like to use data from each of these Pivot tables in order to graph/chart things like: Occurrences in Table2 total X% of all occurrences in table1. And Occurrences in Table 3, are X percent of occurences in T1 and X percent in T2.
Do I need to combine/link the Pivot tables (e.g. via PowerPivot, maybe?) in order to do so?
The types of charts I'm creating are in the Tab "Dashboard".... and the 3 Pivot tables in question are shown in Tab 7 if i'm able to attach a sample. I can also provide a screenshot.
Thoughts???? Thanks in advance.
I have 3 pivot tables all from the same source data. Pivot Table 1 shows all "occurrences". Pivot Table 2 is a subset of all "occurrences" that also have some specific "codes". Pivot Table 3 is a subset of Table 2 that counts only some of the "codes" listed in Table 2.
I'd like to use data from each of these Pivot tables in order to graph/chart things like: Occurrences in Table2 total X% of all occurrences in table1. And Occurrences in Table 3, are X percent of occurences in T1 and X percent in T2.
Do I need to combine/link the Pivot tables (e.g. via PowerPivot, maybe?) in order to do so?
The types of charts I'm creating are in the Tab "Dashboard".... and the 3 Pivot tables in question are shown in Tab 7 if i'm able to attach a sample. I can also provide a screenshot.
Thoughts???? Thanks in advance.
