Subtract constant 1 from pivot table in excel

Question

I have a pivot table with a numerical column. I want to subtract number '1' from 'count of serial number' column. I tried to use Fields, Items, sets and entered formula as = ='Number' - 1. But this gives -1 through out. Not getting what is the mistake.

What I have:Pivot table with Serial number column

Number	calc col
4	-1
24	-1

What I want is below:

Number	calc col
4	3
24	23

Hi Thanks for sharing. I tried the same with subtracting 'Serial No' - 1. But it only gives me -1 as result. :( Not getting why it is printing -1 and not subtracting . — Swethaa
– Swethaa, Commented Nov 7, 2024 at 10:02
Also there is no tutorials or video on google where we can subtract a constant from pivot column. There are videos on subtracting or adding column with another column. In my case it is <column> - 1. — Swethaa
– Swethaa, Commented Nov 7, 2024 at 10:08

SeiryuV · Accepted Answer · 2024-11-08 10:51:59Z

0

here is a small working example.

answered Nov 8, 2024 at 10:51

SeiryuV

1267 bronze badges

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

1 Comment

Swethaa Over a year ago

Hi, Thanks for the reply. Initially I tried this but this only gives me -1 as answer for all rows. But if I subtract 2 pivot rows then it works fine. but not with a pivot column and a constant.

Collectives™ on Stack Overflow

Subtract constant 1 from pivot table in excel

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related