Dynamically adjusting row height based on column shown in pivot table

[chriscools]

Hello,

i have a pivot table and 1 of the expressions is giving the picture of a product when the pivot table is totally folded out.

is it possible to have a row height of 1 as long as the pivot table is not folded out to the last level?

And only when the column with the productname is shown a row height of 4 should be used.

thanx!

Chris

[chriscools]

or is it possible to change row height using a variable?

[Anil_Babu_Samineni]

Not sure, What you are talking about respect variable? But, Are you looking this way

[chriscools]

Hello,

the "size to data" option is allready turned on but that doesn't help.

maybe because that only works for data and not an expression returning an image.

what i meant with a variable is that perhaps i could place an empty variable on the page, and when the pivot

table is folded out untill the lowest level (when i want to see the image) i could put the variable perhaps on "1",

and then the row height could be adjusted to another height...