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.

[dplr-rn]

First of all use set analysis instead of the if statements  much faster and more flexible. check below link and tons of other videos for it

A Primer on Set Analysis

Sum({<TransType={1}>} Qty)

If you use set analysis you can ignore selections if needed

Sum({1<TransType={2}>} Qty)

here 1 ignores all selections

[irmantas]

If I using Sum({1<TransType={2}>} Qty), I see all Items were TransType=2, but I need get only these were TransType=2 and RefId= RefId of Item selected in filter

[dplr-rn]

So you need to ignore just ItemId? if so

Sum({<ItemId=,TransType={2}>} Qty)

[irmantas]

That OK to ignore just ItemId, but I still need relation over RefId. I want sum only Qty of All Items, were RefId is the same as selected in filter Item.

[dplr-rn]

not sure i understand. if selected in filter that selection should be applied.

share a sample app if possible

[vishsaggi]

can you share a sample to look into?

[irmantas]

here we go

[irmantas]

Does some one have any ideas?

[vishsaggi]

Can you tell me your expected output value based on your attached sample?