Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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?
Maybe the visual will be clearer?
Can no one help me? Did I explain the task vaguely?