Distinct Count no longer working in Excel for pivot tables [SOLVED]
Oct 14, 2020 · Distinct Count no longer working in Excel for pivot tables I use a ton of pivot tables on a daily basis, and after an Office update this morning I'm no longer able to calculate distinct counts in …
Distinct Count Function for Mac! - Excel Help Forum
Apr 2, 2019 · Distinct Count Function for Mac! Hi everyone, I was using the distinct count function in pivot tables so it doesn't count duplicates. To have it available, the flag "add this data to data model" …
Subtotal doesnt match the rows it's totalling?! [SOLVED] - Excel Help …
Mar 3, 2023 · Subtotal doesnt match the rows it's totalling?! Hi all, I have a power pivot which is showing the distinct count of a set of data. I have subtotals applied but they don't total the row beneath it. I've …
[SOLVED] Distinct count with multiple criteria - Excel Help Forum
Feb 6, 2025 · Microsoft Office Application Help - Excel Help forum [SOLVED] Distinct count with multiple criteria The use of AI tools (e.g. chatGPT, BARD, GPT4 etc) to create forum answers is not …
Wrong Subtotal in Pivot Table Distinct Count - Excel Help Forum
May 11, 2023 · Hi there, I am encountering a problem with Pivot Table in Excel. I am trying to get Subtotal of Distinct Counts, but the manual total of the Distinct Count is different from the Subtotal …
Pivot Table with Grand Totals for Distinct Counts - Excel Help Forum
Jul 11, 2024 · Re: Pivot Table with Grand Totals for Distinct Counts You can create a formula that will create a fractional value that will then sum to 1 for each unique class, no matter the number of …
[SOLVED] Count / index of distinct items that spills - Excel Help Forum
Dec 16, 2025 · Count / index of distinct items that spills Is it possible to create an index column just for unique items that spills so a,b,c,d ,d,d,a,e = 1,2,3,4,null, null, null, 5 etc a non spill version would be …
Distinct Count option not showing in value field settings in Excel 365 ...
Dec 18, 2022 · The entire table is set up to show individual line items, which means the same order # occurs multiple times. I want to create a pivot table that shows the distinct number of orders vs 'days …
[SOLVED] Pivot Table - Count Distinct - total off by 1 - Excel Help Forum
Jan 15, 2021 · Pivot Table - Count Distinct - total off by 1 I have a pivot table referencing a tab in excel that imports and refreshes my data from another system. I am using the count distinct option in my …
[SOLVED] Count Distinct Months across multiple criteria - Excel Help …
Aug 12, 2022 · Count Distinct Months across multiple criteria I'm new to the forum. Apologies in advance. I'm trying to calculate distinct months across multiple criteria. One limitation is that I don't …