Frequency of output

[MrDolph]

i've made this very simple pivot table that shows how often a set of hospitals (which ID's are called CNES) and that reported their activities month, i will eventually try to fill out the months that the hospitals didn't report based on their available behavior but that's something for another question, what i want to do here is a pie chart graph that shows me the how many (or the frequency in %) of how many hospitals have reported through out all the months (all year around from 2015 to 2022 and the 2 first months of 2023) 

[MarcoWedel]

please post some sample data and your expected result

[MrDolph]

There are over 500 CNES, those being hospital entities and each of them reported their activities along the 98 months (8 years and 2 months from Jan 2015 to Feb 2023) but a good part didn't report every month

CNES	Count(Distinct Data)
3215621	98
3216512	98
3658213	90
3625054	10

i want a pie or a list, that can work too, display:

Amount of Months reported	Amount of CNES that reported this month
98	2
97	X
96	XX
95	XXX

Ideally there'd be a piece of the chart, so a row in the table, for each amount of months reported from 98 to 1 and the size of the pie chart pie would be the amount or % of CNES, of Hospitals, that have at least one entry on that month

[MarcoWedel]

You can use a calculated dimension to get the numbers of months reported: