calculated items

Hello, I need help to find a way to hide zero value calculated items in a pivot table. So far I have tried a number of tricks at no result. I have a database for CO2 tons emissions for 2021 for a number of scopes and subcategories for some countries and locations. I need to compute 2025...

Hi all, Aim: To create a calculated item for G and PG as Kids for movies raw data. A warning is generated and I am unable to insert the Calculated Item. Please find with the below image. I am unable to interpret the message. Any inputs regarding this would be appreciated. Thanks.

I have 3 calculated items in a pivot table - each just sums 3 or 4 other items from the field. Some of the items are summed in multiple calculated items. For example: 'Subtotal1' = 'Item 1' + 'Item 2' + 'Item 3' and 'Subtotal2' = 'Item 3' + 'Item 4' + 'Item 5' Twice now the formulas seem to...

Hi All, please, please consider tackling this, it would be a massive step in moving a career spreadsheet forward! So I have a pivot table that subtotals thousands of mutual funds by "asset classes". The pivot has several Value columns that needed to be ranked (within each sub total). I ranked...

Hello. I have a macro that summarizes a table every month. I created a calculated item to add three branches into a sub region. The issue I have is that if one of the branch's has no volume for a particular month I will get an error because the formula is looking for all three pivot items and...

Hi there, I have read several posts about trying to filter out unwanted "calculated items" when using "calculated item" formulas within a pivot table. The best I have come across thus far is to apply a "Does not equal between -0.00001 and 0.00001" "Value Filter" to either a row or column...

I created a Pivot Table in VBA with Region as the Row Field and Total Sales Amount as the Data Field. I created a calculated Item that adds three of the regions to give me a subtotal. I'm just thinking ahead, but if I update the pivot table one day and one of those three regions is not...

Hi, I'm trying to do something I think of as very simple, but I cannot seem to figure it out. I'm doing a comparison of values (so the same field) with different attributes over time. I'm simply trying to calculate this delta field using fields so that I can dynamically generate the...

I have large tables of sales data with products that are split into various groups. Some managers like sales split into individual groups, for example with the rows showing sales for: Flips Flops Blips Blobs Some managers like the rows combined: Flips & Flops Blips & Blobs Prior to...

Hello. I am trying to create a pivot table that tracks debits versus credits over time. Debits and Credits are captured within the same field, "Transaction Type." I would like to subtract debits from credits in a new column. My pivot table has the following design: Row Labels:Month Column...

I am building pivot tables off a data table that includes orders for training events ('Order Table'). In this table each row signifies 1 order. Each event has a unique event ID, so in this table there are usually several rows for the same event (1 for each order the event had). For each order...