Appearance of columncontent on depending on selection of dimension

[beck_bakytbek]

Hi Folks,

i am facing with the following situation (please see attached screenshot).

is that possible to make visible the content of column if i select the certain dimension. for instance: my pivot table consists of 3 Dimension: Projectmanager, Project, Costcenter,and if i select Dimension: Project i want see the column: Comments only for Dimension: Project.

is that possible? Does have anybody any idea?

Thanks a lot

Beck

[dan_sullivan]

could you use a formula to color code the comments white if the conditions were not met to artificially hide them from being visible?

[beck_bakytbek]

i dont see your point, what do you mean with "formula to color code"

[dan_sullivan]

within a pivot table you have the option to change the color of the text.  so write a formula that will make the color of text white until the user selects a project.

example:   if(GetFieldSelections(project)=0,White(),Blue())

[beck_bakytbek]

Hi Dan,

first of all thanks a lot for your feedback, in my case i am facing with problem of appearance of content of column not of color of column. i.e: if i select dimension: Project i want only see the column: comment. in pivot table if i select any dimension, the pivot tables shows me always the column: comment. i try to create the dependence between dim: Project and Column: Comment. i hope, i explained well.

Thanks a lot

Beck