carljohanlarsson
New Member
- Joined
- Feb 16, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi, I have a tablet that looks like this:
<DATE><DOMAIN><YES/NO>
I have created a pivot with the rows DOMAIN and the columns DATE. I then have these values:
the number of rows (count(something)
and the number of YES (sum of all 1)
It looks like this:
[IMG alt="thumbnail image 1 of blog post titled
Pivot table question
"]https://techcommunity.microsoft.com...27A34A07F/image-size/medium?v=v2&px=400[/IMG]
I would instead like to display the % of yes, and only the %.
For the life of me, I can't figure this out, any tips?
<DATE><DOMAIN><YES/NO>
I have created a pivot with the rows DOMAIN and the columns DATE. I then have these values:
the number of rows (count(something)
and the number of YES (sum of all 1)
It looks like this:
[IMG alt="thumbnail image 1 of blog post titled
Pivot table question
"]https://techcommunity.microsoft.com...27A34A07F/image-size/medium?v=v2&px=400[/IMG]
I would instead like to display the % of yes, and only the %.
For the life of me, I can't figure this out, any tips?