Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My end user wants to view different background image for pivot table depending upon selection in region field.
How to achieve this?
take a look at attached file for details of my requirement.
Thank you.
This is also not usable in my case.
Still,I'm not able to change background image using this option.
hi
if this helps you, then you should give helpful.
thanks.
I would cheat a little - see attached.
Hi Rebecca,
Can you please tell us , where/how you have used that Inline Field 'Image' in properties of pivote table ?
It actually isn't in the pivot table. That's what I meant by saying I "cheated" a little, sorry. If you move the pivot table, you will notice that the image is actually behind the pivot table, with the pivot background set to be transparent. Hope that helps!
You could "cheat" by making multiple pivot tables that are exactly the same but with the difference being the selected background picture under "Style" -> "Background". Then under "Layout" -> "Show" select conditional, and show the different tables depending on user selections.
Good luck,
Regards