Display data conditionally in Table Box

[nihhalmca]

Hi All,

How can i display data conditionally in Table box only. For example Dims are Year, Qtr and Month.

Condition should be Year =2016.

Thanks,

Nihhal.

[nihhalmca]

Hi Jonathan - If i do with straight table have to hide measure. there is a way to create straight table without measure.

Nihhal.

[sunny_talwar]

You can hide columns in straight table on the presentation tab

[avinashelite]

table box doesn't allow you to write any expression , you need to write the conditions in the script and use the fields in front end 

[nihhalmca]

Hi Santiago - Thanks for your response.

I want to do it in table box itself.

If i do with straight table there is a layout difference for example total row. (we can use hide colum however, still total row appear at top or bottom of table).

Hope you understand.

Nihhal.

[PrashantSangle]

Hi,

Use no Total in expression tab.

It will hide total of expression in Straight table.

Kind Regards,

[Anonymous]

in layout and give the condition at condtion Year=2016