How to display the dimensions conditionally?

[pgrs4219]

Hi Community,

I have a requirement that i need to display the dimension of the chart conditionally by making the selections in the drop down list of pivot table.

So please help me with this. Here is the sample attachment please go through that.

Thanks

[vishsaggi]

Use like in Dimensions -> Enable Conditional check

= IF(GetSelectedCount(ArticleNo) > 0, 1, 0)

Check the attached. You want to display only when ArticleNo is selected or individual dimensions selected.

Just use the above if conditions for different dimensions in your source table.

= IF(GetSelectedCount(Batch) > 0, 1, 0)  for Batch Dimension

= IF(GetSelectedCount(Week_No) > 0, 1, 0) for week dimension.

[Anonymous]

On the dimensions tab of your pivot table select 'Enable Conditional".

Enter formula like:  =GetSelectedCount(ArticleNo)<>0

Replace 'ArticleNo' with the dimension name.

[pgrs4219]

Hi Nagaraju,

Thanks you so much for your quick reply,

the above conditions are helped me, but i want to do the multiple dimension selections randomly, so can you suggest me for that also.

for example i want to select both ArticleNo and Batch at time  i know i can use  the below condition

IF(GetSelectedCount(ArticleNo) > 0, 1, 0)

or IF(GetSelectedCount(Batch) > 0, 1, 0)

But  if i  do that i can see the  Artical no while selecting the batch also. so i need some dynamic approach. please help me with this also.

Thanks

[vishsaggi]

So when you have no selections in ArticleNo and a selection in the Batch what is that you want to see?