Show/Hide a field based on selection

[raju_salmon]

Hi,

I need to create a table with Grouped dimension of Year,Quarter, Month, Date. And i have a field called DAY (Mon, Tue etc).

I need to show DAY field as dimension along with above group.

When user select Date from Cyclic Group, then DAY dimension in Straight table should be displayed. Can anyone help what kind of condition we can write in Calculation dimension of DAY field?

Unfortunately i cannot able to share the data

Thanks.

[sunny_talwar · Accepted solution]

Instead of calculated dimension, try using conditional hide/show for your dimension Day. The condition should be like this:

GetCurrentField([Group Name]) = 'Date'

[raju_salmon]

Hi Sunny,

Thanks for response, i have tried it with Day field, but it is not working, since at group name it is showing error.

GetCurrentField(<Grp_Date) = 'Date'

[sunny_talwar]

Not sure what is < sign used for? Is that part of your group name?

[raju_salmon]

Yes Sunny, followed as General practice for cyclic group. I have removed and tried.. it is working. Thanks alot.

[sunny_talwar]

Did your own response help you out? I would suggest not marking your own response as correct if it was not truly a correct response as it won't be helpful for others in the future

[raju_salmon]

Hi Sunny,

Sorry, just observer i made wrong selection as correct answer... thank for your comment to make it correct.