Forum Discussion

MPachecoVieira's avatar
MPachecoVieira
Copper Contributor
May 24, 2019
Solved

PivotTable Column calculated with the count formula.

 

I created a PivotTable with a column (A) that counts the number of records of an item.
How do I add another column (B) with the value of column (A) multiplied by a number?
I tried with calculated fields but I was not able to get the results I wanted.

 

Best regards to all

excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    May 25, 2019

    MPachecoVieira , creating your PivotTable add data to data model

    Right click on your table as here

    and add measure. It could be like this

    Add measure to the Values of your PivotTable, finally you have

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    May 25, 2019

    MPachecoVieira , creating your PivotTable add data to data model

    Right click on your table as here

    and add measure. It could be like this

    Add measure to the Values of your PivotTable, finally you have