8 Replies Latest reply: Mar 22, 2017 9:40 AM by beck bakytbek RSS

    pivot table like this

    beck bakytbek

      Hi Folks,


      i got question, i have a pivot table (please see attached example)


      above table is my current table, the below table is my expected output,

      i have 3 Dimension: year, project, cost center and as expression i am using: count(contract)


      how can i exlude values within pivot table: i mean, i want just show the expression: count (contract) to dimension: project

      (please see attached example and below table)


      thanks a lot