Forum Discussion
DaveK25483
Oct 02, 2021Copper Contributor
Trying to count text using a date as reference
Need help to count the number of items based on a date. my dates 01-Dec through to 25-dec are in column c. the items i need to count are in columns d through to ac there are 9 possible types of item...
- Oct 05, 2021Brilliant 🙂
Only problem my mac doesn't support slicers 🙂 but really thank you much appreciated
rgds
Yea_So
Oct 05, 2021Bronze Contributor
I modified it full Pivot View with slicers if its counts you need counts you will get:
Sliced View:
Sliced View with two party times:
DaveK25483
Oct 05, 2021Copper Contributor
Brilliant 🙂
Only problem my mac doesn't support slicers 🙂 but really thank you much appreciated
rgds
Only problem my mac doesn't support slicers 🙂 but really thank you much appreciated
rgds
- DaveK25483Oct 05, 2021Copper Contributor🙂 🙂 like it...
- Yea_SoOct 05, 2021Bronze Contributor
That's your business we're talking about, If you want to drive a ferrari in the numbers farm suit yourself or you can buy a Windows Pick-up truck for your farm. Its your business.
cheers