PivotTable button show only over 100 value columns

[kkarlste]

I don't understand how I can do this button

PivotTable button show only over 100 value columns

[aruneshgupta]

Can you please explain or provide example ?

[kkarlste]

I must show on pivot table hours are only over 80 h per week.
I must in addition, you must be selected year

This is the formula with which the hours are now calculated in the pivot table
sum (Hours)

I want button or something
that I can show the table cell only by pressing the button more than 80 hours

[kkarlste]

I don't know  this not working,
I want all hours = työtunnit
And I want dimension where over 80 hours

(FAKTA)

LOAD 

//     ApplyMap('Date_to_Period', text(date(pvm8,'YYYYMMDD'))) as Period,

    ApplyMap('Date_to_Period', text(date(pvm8,'YYYYMMDD'))) & '|' & text(date(pvm8,'YYYYMMDD')) as %DateKEY,

//     text(date(pvm8,'YYYYMMDD')) as pvm8,

    heno as personnr,

    callname,

    lastname,

text('000'&costcenter) as ProfitCenter,

    liiketoimintayksikkonimi,

    liiketoimintayksikkoselite,

    palveluyksikkonimi,

    palveluyksikkoselite,

    palvelualuenimi,

    palvelualueselite,

 sum ( tunnit > '80') as over80,

    tunnit as Työtunnit;

SQL SELECT convert (datetime,pvm8) as pvm8,

    heno,

    callname,

    lastname,

    costcenter,

    liiketoimintayksikkonimi,

    liiketoimintayksikkoselite,

    palveluyksikkonimi,

    palveluyksikkoselite,

    palvelualuenimi,

    palvelualueselite,

    tunnit

FROM ISSQlikView.dbo."tb_src_HR_employee_working_hours_day_level";