nparsons75
Well-known Member
- Joined
- Sep 23, 2013
- Messages
- 1,254
- Office Version
- 2016
Hi,
I have a pivot table with changes on the use of a slicer. I need to have a count of the number of days in the list. In the example, the count should be 14. I have tried adding a new calculated field but cant get the answer i need, 14. Any help appreciated.
I have a pivot table with changes on the use of a slicer. I need to have a count of the number of days in the list. In the example, the count should be 14. I have tried adding a new calculated field but cant get the answer i need, 14. Any help appreciated.
Row Labels |
03/08/2021 |
04/08/2021 |
05/08/2021 |
09/08/2021 |
11/08/2021 |
12/08/2021 |
13/08/2021 |
18/08/2021 |
19/08/2021 |
20/08/2021 |
23/08/2021 |
25/08/2021 |
27/08/2021 |
31/08/2021 |
Grand Total |