Pivot issue

[Luigi64]

Hello
could you help me to find a solution for this topic:
how can I put into Excel Pivot a Name and not a Value, or better, a name and also its related image?
How can I do it?
That means:
Colum A crossed to Row A (for ex) and I would like to see not a value in the cross but the content of another excel field, for ex. a name of the tool
I hope I explained quiet well my issue..

 

[Chihiro]

See link for method using CF.
http://chandoo.org/wp/2012/05/07/displaying-text-values-in-pivot-tables-without-vba/

However, note the limitations. PivotTable is meant to be data analysis tool and not really meant for what you are looking to accomplish.

Though I've never really worked with images much myself. You can accomplish something like this via PowerQuery, PowerPivot & PowerView. See like for details.

http://www.kasperonbi.com/loading-an-image-into-the-model-using-power-query/

 

[Luigi64]

hello, thanks for replay
Actually I expect exactly what you suggested: some other way to do what in std way isn't possible
I'll investigate PowerQuery, PowerPivot & PowerView