Excel pivot table "Count of"; calculate for 80

Question

I have a list of items :

"Partner"

A
A
B
B
B
C

I create a Pivot table over these, to counf of many occurrences I have of A, B and C. The result:

"Row label"  "Count of Partner"

A            2
B            3
C            1

Now, I would like to have a calculation based on the "Count of Partner"

= "Amount" = "Count of Partner"*80

"Row label"  "Count of Partner" "Amount"
A            2                  160
B            3                  240
C            1                  80

It seems simple... but, I don't really find a solution. I could for sure copy do the calculation out of the pivot table, but I would loose the dynamic of data.

Can you please help?

Thank you,

Possible duplicate of Creating Calculated Field with SUM and COUNT of Fields Pivot Table — GSerg
– GSerg, Commented Jul 16, 2020 at 10:03

Vivs · Accepted Answer · 2020-07-16 10:10:43Z

0

You can do this my adding a new measure to the range. just right click on range and add measure. Mention the formula as [Count of Partner]*80 refer the image below

answered Jul 16, 2020 at 10:10

Vivs

4854 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Stéphanie Cettou · Accepted Answer · 2020-07-23 11:46:29Z

0

thank you! I had to look a bit, as this option is not available with the normal Pivot Table version. I had to activate the "Power Pitot" Option.

answered Jul 23, 2020 at 11:46

Stéphanie Cettou

31 bronze badge

Collectives™ on Stack Overflow

Excel pivot table "Count of"; calculate for 80

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related