to hide selected quarter in straight table

[#1]

Hi,

     I have scenarion in this i have a straight table to show quarter based calculation the chart is attached below for that i need four buttons for four quarters when i click on first button chart will hide quarter1 details for second button chart will hide quarter2 details like that i need four buttons for four quarters plz help me to solve this scenario

thanks

[settu_periasamy]

Hi,

Create Four Variable and Create Four Buttons, Assign the variables for them. Then you can use that variable in the Conditonal display in the Expression Tab.

Edit: Attached the Sample

[#3]

hi

settu perisamy  whatever you done is good but scenario is i have 2001Q1 and 2002Q1 and 2003Q1 like that  for four quarters in this whenever i clik on q1 button need to hide all 2001Q1  and 2002 Q1 and 2003Q1 from chart   like that for all Quarters plz help me

thanks

[settu_periasamy]

Hi,

are you using pivot table or straight table?

[#5]

straight table

[settu_periasamy]

Then, just you can give the variable as conditional, wherever you have 20**Q1 expression and like vise..

if it is not work, provide the sample.

[#7]

thank you so much

[jagan · Accepted solution]

Hi Praveen,

Please find attached file for solution, used the same file of settu_periasamy

[#9]

thank you jagan u done a great job