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

      beck