Hi<o></o>
I have the following pivot table created from apower pivot table, linked to SQL data base. When I select the Grand Total (68) it does not display the 68 recordsbut instead opens the whole table related to the pivot table source. It wasworking fine before. <o></o>
<tbody>
</tbody>
<o> </o>
I did another new Pivot, based on the samefiltering and it behaves the same, what do I need to set to only show thefiltered 68 records.<o></o>
Thanks<o></o>
I have the following pivot table created from apower pivot table, linked to SQL data base. When I select the Grand Total (68) it does not display the 68 recordsbut instead opens the whole table related to the pivot table source. It wasworking fine before. <o></o>
ASC - Job State Age Period<o></o> | ||||||||
AOI Claimed<o></o> | 1<o></o> | |||||||
task_Org<o></o> | (Multiple Items)<o></o> | |||||||
Count of Reference_Order_No<o></o> | Job_State<o></o> | |||||||
JS_Period<o></o> | RFA<o></o> | EXE<o></o> | CDR<o></o> | CNR<o></o> | TND<o></o> | CANRE<o></o> | CAC<o></o> | Grand Total<o></o> |
0-10<o></o> | 34<o></o> | 7<o></o> | 3<o></o> | 1<o></o> | 1<o></o> | 1<o></o> | 47<o></o> | |
61-90<o></o> | 1<o></o> | 1<o></o> | ||||||
11-20<o></o> | 1<o></o> | 1<o></o> | 5<o></o> | 1<o></o> | 8<o></o> | |||
21-30<o></o> | 1<o></o> | 2<o></o> | 3<o></o> | |||||
31-45<o></o> | 1<o></o> | 1<o></o> | ||||||
46-60<o></o> | 1<o></o> | 1<o></o> | 2<o></o> | |||||
121-240<o></o> | 1<o></o> | 2<o></o> | 3<o></o> | |||||
91-120<o></o> | 1<o></o> | 2<o></o> | 3<o></o> | |||||
Grand Total<o></o> | 36<o></o> | 9<o></o> | 1<o></o> | 15<o></o> | 1<o></o> | 3<o></o> | 3<o></o> | 68<o></o> |
<o> </o>
I did another new Pivot, based on the samefiltering and it behaves the same, what do I need to set to only show thefiltered 68 records.<o></o>
Thanks<o></o>