PivotTable exlude Dimensions from filter

[irmantas]

Hello,

How to create second Pivot table in same document, and show list dimensions with excluding of filtering and first PivotTable.

How I can create other Pivot Table were show all ItemId were TransType=2 and excluding ItemId filter.

[irmantas]

try select ex. Z-GPS-GRANU in ItemId filter. In first PivotTable we see sum of Z-GPS-GRANU QTY were TransType=1, and Aggr of QTY were this RefId and TransType=2

in red square I want to see Pivot detailed Aggr function, all items were TransRefId the same as Z-GPS-GRANU, but TransType=2

[vishsaggi]

NOt sure i understood your requirement sorry. Can you tell what is that you want to see in your other Pivot when you select an item?

[irmantas]

Maybe the visual will be clearer?

[irmantas]

Can no one help me? Did I explain the task vaguely?