Jul 14 2022 10:31 PM
I have a table with 6 columns (primary group, subsidiary, COO, month, and metric -which can only be Cost and Units Produced in the rows- and also values).
I created a Pivot table with the primary filter being "primary group", column headings layered into COO, subsidiary, and metric, and rows being the month. Then I added a calculated item under the metric, "Cost / Units Produced".
However, when I select a primary group (using the filter), all the unrelated subsidiaries are also appearing in the pivot table (albeit with no values). I am confused. Can anyone help?
Jul 15 2022 12:26 AM
Hi @abdur2790
I know that calculated items cause troubles with the page filters. Unfortunately, it seems to be a bug (aka unwanted feature) in Excel. At least, I have not seen any solution for this.