hide column in straight table if value is '0'(zero)

[#1]

hi Folks,

how can i hide column in straight table if the field value is 0

[kaushiknsolanki]

Hi,

     You can use the conditional show feature of straight table.

     Go to properties -> Presentation -> Click on the dimension/expression you want to hide. and type the condition in "conditional".

Regards,

Kaushik Solanki

[#3]

hi kaushik,

sum(revenue) for account1=40,324 & account 2 revenue=351047,account 3 =199641  like that

while selecting account 1 it displays remaining accounts  as '0'

my requirement is it shouldnt show remaining accounts .

Account   1             2          3

1           40,324       0          0

2             0          351047     0

3            0           0             100000

[#4]

hi kaushik,

sum(revenue) for account1=40,324 & account 2 revenue=351047,account 3 =199641  like that

while selecting account 1 it displays remaining accounts  as '0'

my requirement is it shouldnt show remaining accounts .

thanks in advance

[kaushiknsolanki]

Hi,

     Can you please upload sample data.

Regards,

Kaushik Solanki

[#6]

hi kaushik,

i already attached sample straight table data as excel file,

plz find the attachment above

[kaushiknsolanki]

Hi,

     The xls you had uploaded contains the output you want. Am i right..?

     If i m right then i am looking for the raw data.

     Also explain indetail with an example what you want cause i am still not clear with your requirements.

Regards,

Kaushik Solanki

[#8]

hi kasshik,

the excel file is sample straight table data in my qvw.

here my requirement is condition hide of account dimension data.

ex: if i click account 1 it shouldnt display account 2,3 , y because they r 0's

excel sheet itself my sample data in my straight table

[kaushiknsolanki · Accepted solution]

Hi,

     Have a look at the sample application attached here with.

Regards,

Kaushik Solanki

[#10]

thanks kaushik,

its worked fine