Pivot Table - Conditional Expression

[Anonymous]

Is there a way to condition an Expression column in a Pivot Table so that it only shows when a particular Dimension is expanded?

[susovan]

Hi,

Its might be work.

"SubStringCount(Concat(Heading, '|'), 'Field name')"

Write down this above expression in below mentioned place.

[Anil_Babu_Samineni]

Yes Your query looking like sub Total. I am not sure

Anyway, Can you please share me the Sample Application

[Anonymous]

Apologies, I meant Pivot TABLE not Chart.  I've amended the original post.

[susovan]

Yes, it also possible in Pivot table.

[sunny_talwar]

You might be able to use Dimensionality() or SecondaryDimensionality() function to do this. For exact expression to be used, you will need to provide more details about the number of dimensions you have and when the particular dimension should be visible and when should it be not visible. Would you be able to share a sample may be?