Need to hide the last three highlighted columns in the right

[trishita]

I want to hide the last 2 columns of my chart.I have used them to create a column but dont want them to appear in the report.What is the possibility to do it? 

[amrinder]

Hey Tri**bleep**a,

Under Measure properties there is option of " Show Column If" Under that type 0(Zero) and it will hide your specific column.

Hope it helps.

-amrinder

[amrinder]

Hey Tri**bleep**a,

Under Measure properties there is option of Show Column If Under that type 0(Zero) and it will hide your specific column.

Hope it helps.

-amrinder

[Channa]

if it is Pivot create measure in Valuelist

Dimension Row : Company

Column : ValueList('Column1','Column1','Column3')

Measure :

pick(match(ValueList('Column1','Column1','Column3'),'Column1','Column1','Column3'),
sum({<equipment={'officer'}>}Column1),
sum({<equipment={'backrest'}>}Column2),
(sum({<equipment={'officer'}>}value)-sum({<equipment={'backrest'}>}value))
)

[trishita]

I am currently using normal table e chart expression

[trishita]

it does not help as it is affecting the other columns