How to show selected menu in slicer to other cell ??? (Like a Refrence Indication)

[krunal123]

@ How to show selected menu in slicer to other cell ??? (Like a Reference Indication) in pivot table ????

I have Try selection in slicer information reference to other cell , Above image like this yellow Highlight cell this reference

 

[GraH]

Make a second pivot containing the Port of Loading in rows. Nothing else.
Make sure to connect your slicer to this pivot as well.
Then try something like below.

 

[krunal123]

Make a second pivot containing the Port of Loading in rows. Nothing else.
Make sure to connect your slicer to this pivot as well.
Then try something like below.
View attachment 44792

Kindly pleased step by step tutorial

 

[GraH]

Copy this pivot and put it on another sheet (slicer will be connected to the copy as well). Remove everything from this pivot. Then add the Port of Loading field in the rows of the pivot. Remove all grand totals via the pivot options.
Say the pivot is on Sheet2 and starts in the range A2 and continues down. The formula becomes*:

 =IF(SHEET2!A12<>"", "Too many values in selection", TEXTJOIN(", ", TRUE, SHEET2!A2:A11))

* adapt the references as those depend on the number of Ports you would allow people to select via the slicer. In this case up to 10 would be allowed.