I have a functioning Pivot Table in a LibreOffice Calc file. I just added a new category, which shows up in the primary dropdown list. I also added a dependent dropdown list for that new category, but it doesn’t show up in the pivot table. I’ve defined the range and done data validation, to no avail. Older dropdown lists in my pivot table work fine. Can anyone help with this? Thank you.
