Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
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))
)
I am currently using normal table e chart expression
it does not help as it is affecting the other columns