Calculated Item - How to associate it with only one pivot table

[Lacherlich]

Hello

I was wondering if there was a way to allocate a calculated item to only one pivot table on my spreadsheet. I.e all of the pivot tables use the same source data, but when I add a calculated item to one pivot, it shows as an option for all my pivots. I'm not sure how the logic works, but it seems that having all of these calculated items against every pivot table slows it down a lot.

I want to have the option to add a different calculated item to each pivot table - is this even possible and would it help speed up the report? When I use a slicer to incorporate extra data, it takes ages to calculate everything.

Many Thanks

 

[RoryA]

If they share a source, any calculated field/item will appear for all of them. There is no way round that, so you'd have to use separate sources, but then you can't share slicers.

I find calculated items to be very slow so if you can create them in the source data, it's usually better.

 

[Lacherlich]

Hey

Thanks for the quick reply. Ill just add the formulas in manually underneath the pivots. Was just hoping pivots could solves all my woes. The data source is too big to add it in there, in terms of how its laid out etc.

Cheers