Pivot - Slow calculated items

Hi,

I have a very big database (around 100k entries) that shows on a pivot table.
I wish to add very simple calculated items to that pivot, sum items in different categories (collumns in the db) to create new categories. But when those calculated items are added, doing anything with the pivot gets very very slow or hangs excel (say, adding a filter or removing a field).
The calculations themselves are not complicated, because if I just do them by hand, outside the pivot, it does not get slowed down at all. But, of course, I lose all the flexibility the pivot table gives me.
Do you have any pointers on how to make it run faster or on different ways of doing it?

Thanks

Using less data would help, but I have to use the entire db as all data there is important

My DB is shaped like this:

Category	Value	Other Cols
A	1
B	2
B	4
A	7

And what I want to do is create a third category (C), that would be A+3*B.
There are several other cols involved that add complexity to the problem (hence using a PT to analyse it).

that's why I don't think I can do the calc inside the DB, because I'd have to set up a VBA code for that which would add even more entries to the bank. Or maybe I can and just don't know how?

Thanks

How would that be done in the DB format example I posted? The values I want to work with are in several different rows.

I have attached an example to clarify what I'm saying.
The data tab represents what I have in my DB (input), the pivot is what I would like to see (outcome), and the formulas there show the calculations that would be done.

For this small dataset there are no problems at all adding stuff like a filter by the "year" field or anything. But with more data, that would be highly impractical because of the calculated fields.

MWE_slow_pivot.xlsx

Thanks!

You are kind of doing a pivot table by hand there hehe
I don't think that would work tho, since others tend to poke around with the shape of the pivot, not just with the filters. Like, adding other cols for side-by-side comparisons and stuff.
Thanks for the help though I really appreciate it.
If you have any other ideas let me know :D

Krones/Anyone else, did you ever find a solution to speed up the calculated items? I am currently having a similar issue with them