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
>
[TABLE="class: MsoNormalTable, width: 722"]
<tbody>[TR]
[TD="width: 207"] ASC - Job State Age Period<o
></o
>
[/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 135, bgcolor: transparent"][/TD]
[TD="width: 117, bgcolor: transparent"][/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 99, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 207"] AOI Claimed<o
></o
>
[/TD]
[TD="width: 107"] 1<o
></o
>
[/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 135, bgcolor: transparent"][/TD]
[TD="width: 117, bgcolor: transparent"][/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 99, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 207"] task_Org<o
></o
>
[/TD]
[TD="width: 107"] (Multiple Items)<o
></o
>
[/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 135, bgcolor: transparent"][/TD]
[TD="width: 117, bgcolor: transparent"][/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 99, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 207, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 135, bgcolor: transparent"][/TD]
[TD="width: 117, bgcolor: transparent"][/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 99, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 207"] Count of Reference_Order_No<o
></o
>
[/TD]
[TD="width: 107"] Job_State<o
></o
>
[/TD]
[TD="width: 67"][/TD]
[TD="width: 135"][/TD]
[TD="width: 117"][/TD]
[TD="width: 80"][/TD]
[TD="width: 71"][/TD]
[TD="width: 81"][/TD]
[TD="width: 99"][/TD]
[/TR]
[TR]
[TD="width: 207"] JS_Period<o
></o
>
[/TD]
[TD="width: 107"] [/TD]
[TD="width: 67"] [/TD]
[TD="width: 135"] [/TD]
[TD="width: 117"] [/TD]
[TD="width: 80"] [/TD]
[TD="width: 71"] [/TD]
[TD="width: 81"] [/TD]
[TD="width: 99"] [/TD]
[/TR]
[TR]
[TD="width: 207, bgcolor: transparent"] 0-10<o
></o
>
[/TD]
[TD="width: 107, bgcolor: transparent"] [/TD]
[TD="width: 67, bgcolor: transparent"] [/TD]
[TD="width: 135, bgcolor: transparent"][/TD]
[TD="width: 117, bgcolor: transparent"] [/TD]
[TD="width: 80, bgcolor: transparent"] [/TD]
[TD="width: 71, bgcolor: transparent"] [/TD]
[TD="width: 81, bgcolor: transparent"] [/TD]
[TD="width: 99, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="width: 207, bgcolor: transparent"] 61-90<o
></o
>
[/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 135, bgcolor: transparent"][/TD]
[TD="width: 117, bgcolor: transparent"] [/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 99, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="width: 207, bgcolor: transparent"] 11-20<o
></o
>
[/TD]
[TD="width: 107, bgcolor: transparent"] [/TD]
[TD="width: 67, bgcolor: transparent"] [/TD]
[TD="width: 135, bgcolor: transparent"][/TD]
[TD="width: 117, bgcolor: transparent"] [/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"] [/TD]
[TD="width: 99, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="width: 207, bgcolor: transparent"] 21-30<o
></o
>
[/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"] [/TD]
[TD="width: 135, bgcolor: transparent"][/TD]
[TD="width: 117, bgcolor: transparent"] [/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 99, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="width: 207, bgcolor: transparent"] 31-45<o
></o
>
[/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 135, bgcolor: transparent"][/TD]
[TD="width: 117, bgcolor: transparent"][/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"] [/TD]
[TD="width: 99, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="width: 207, bgcolor: transparent"] 46-60<o
></o
>
[/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 135, bgcolor: transparent"] [/TD]
[TD="width: 117, bgcolor: transparent"] [/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 99, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="width: 207, bgcolor: transparent"] 121-240<o
></o
>
[/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 135, bgcolor: transparent"][/TD]
[TD="width: 117, bgcolor: transparent"] [/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"] [/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 99, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="width: 207, bgcolor: transparent"] 91-120<o
></o
>
[/TD]
[TD="width: 107, bgcolor: transparent"] [/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 135, bgcolor: transparent"][/TD]
[TD="width: 117, bgcolor: transparent"] [/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 99, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="width: 207"] Grand Total<o
></o
>
[/TD]
[TD="width: 107"] [/TD]
[TD="width: 67"] [/TD]
[TD="width: 135"] [/TD]
[TD="width: 117"] [/TD]
[TD="width: 80"] [/TD]
[TD="width: 71"] [/TD]
[TD="width: 81"] [/TD]
[TD="width: 99"] [/TD]
[/TR]
</tbody>[/TABLE]
<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


[TABLE="class: MsoNormalTable, width: 722"]
<tbody>[TR]
[TD="width: 207"] ASC - Job State Age Period<o


[/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 135, bgcolor: transparent"][/TD]
[TD="width: 117, bgcolor: transparent"][/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 99, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 207"] AOI Claimed<o


[/TD]
[TD="width: 107"] 1<o


[/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 135, bgcolor: transparent"][/TD]
[TD="width: 117, bgcolor: transparent"][/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 99, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 207"] task_Org<o


[/TD]
[TD="width: 107"] (Multiple Items)<o


[/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 135, bgcolor: transparent"][/TD]
[TD="width: 117, bgcolor: transparent"][/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 99, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 207, bgcolor: transparent"][/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 135, bgcolor: transparent"][/TD]
[TD="width: 117, bgcolor: transparent"][/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 99, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="width: 207"] Count of Reference_Order_No<o


[/TD]
[TD="width: 107"] Job_State<o


[/TD]
[TD="width: 67"][/TD]
[TD="width: 135"][/TD]
[TD="width: 117"][/TD]
[TD="width: 80"][/TD]
[TD="width: 71"][/TD]
[TD="width: 81"][/TD]
[TD="width: 99"][/TD]
[/TR]
[TR]
[TD="width: 207"] JS_Period<o


[/TD]
[TD="width: 107"]
RFA<o
></o
>


[TD="width: 67"]
EXE<o
></o
>


[TD="width: 135"]
CDR<o
></o
>


[TD="width: 117"]
CNR<o
></o
>


[TD="width: 80"]
TND<o
></o
>


[TD="width: 71"]
CANRE<o
></o
>


[TD="width: 81"]
CAC<o
></o
>


[TD="width: 99"]
Grand Total<o
></o
>


[/TR]
[TR]
[TD="width: 207, bgcolor: transparent"] 0-10<o


[/TD]
[TD="width: 107, bgcolor: transparent"]
34<o
></o
>


[TD="width: 67, bgcolor: transparent"]
7<o
></o
>


[TD="width: 135, bgcolor: transparent"][/TD]
[TD="width: 117, bgcolor: transparent"]
3<o
></o
>


[TD="width: 80, bgcolor: transparent"]
1<o
></o
>


[TD="width: 71, bgcolor: transparent"]
1<o
></o
>


[TD="width: 81, bgcolor: transparent"]
1<o
></o
>


[TD="width: 99, bgcolor: transparent"]
47<o
></o
>


[/TR]
[TR]
[TD="width: 207, bgcolor: transparent"] 61-90<o


[/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 135, bgcolor: transparent"][/TD]
[TD="width: 117, bgcolor: transparent"]
1<o
></o
>


[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 99, bgcolor: transparent"]
1<o
></o
>


[/TR]
[TR]
[TD="width: 207, bgcolor: transparent"] 11-20<o


[/TD]
[TD="width: 107, bgcolor: transparent"]
1<o
></o
>


[TD="width: 67, bgcolor: transparent"]
1<o
></o
>


[TD="width: 135, bgcolor: transparent"][/TD]
[TD="width: 117, bgcolor: transparent"]
5<o
></o
>


[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"]
1<o
></o
>


[TD="width: 99, bgcolor: transparent"]
8<o
></o
>


[/TR]
[TR]
[TD="width: 207, bgcolor: transparent"] 21-30<o


[/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"]
1<o
></o
>


[TD="width: 135, bgcolor: transparent"][/TD]
[TD="width: 117, bgcolor: transparent"]
2<o
></o
>


[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 99, bgcolor: transparent"]
3<o
></o
>


[/TR]
[TR]
[TD="width: 207, bgcolor: transparent"] 31-45<o


[/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 135, bgcolor: transparent"][/TD]
[TD="width: 117, bgcolor: transparent"][/TD]
[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"]
1<o
></o
>


[TD="width: 99, bgcolor: transparent"]
1<o
></o
>


[/TR]
[TR]
[TD="width: 207, bgcolor: transparent"] 46-60<o


[/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 135, bgcolor: transparent"]
1<o
></o
>


[TD="width: 117, bgcolor: transparent"]
1<o
></o
>


[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 99, bgcolor: transparent"]
2<o
></o
>


[/TR]
[TR]
[TD="width: 207, bgcolor: transparent"] 121-240<o


[/TD]
[TD="width: 107, bgcolor: transparent"][/TD]
[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 135, bgcolor: transparent"][/TD]
[TD="width: 117, bgcolor: transparent"]
1<o
></o
>


[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"]
2<o
></o
>


[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 99, bgcolor: transparent"]
3<o
></o
>


[/TR]
[TR]
[TD="width: 207, bgcolor: transparent"] 91-120<o


[/TD]
[TD="width: 107, bgcolor: transparent"]
1<o
></o
>


[TD="width: 67, bgcolor: transparent"][/TD]
[TD="width: 135, bgcolor: transparent"][/TD]
[TD="width: 117, bgcolor: transparent"]
2<o
></o
>


[TD="width: 80, bgcolor: transparent"][/TD]
[TD="width: 71, bgcolor: transparent"][/TD]
[TD="width: 81, bgcolor: transparent"][/TD]
[TD="width: 99, bgcolor: transparent"]
3<o
></o
>


[/TR]
[TR]
[TD="width: 207"] Grand Total<o


[/TD]
[TD="width: 107"]
36<o
></o
>


[TD="width: 67"]
9<o
></o
>


[TD="width: 135"]
1<o
></o
>


[TD="width: 117"]
15<o
></o
>


[TD="width: 80"]
1<o
></o
>


[TD="width: 71"]
3<o
></o
>


[TD="width: 81"]
3<o
></o
>


[TD="width: 99"]
68<o
></o
>


[/TR]
</tbody>[/TABLE]
<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


Thanks<o

