Forum Discussion
Count Distinct Cumulative for Pareto
I have table like below: Year Month Region Product Item Value 2025 1 Asia Product A Item A1 100 2025 1 Asia Product A Item A2 100 2025 1 Asia Product A Item A3 20...
Hi,
Here is an alternate solution using certified, custom visual "Pareto by sio2Graphs".
*make sure data does not include blanks when using below formula.
Percent = FORMAT(DIVIDE(COUNT(Sheet1[Item]),COUNTROWS(ALLSELECTED('Sheet1')),1),"Percent")
cynthia@sio2Graphs.com
easy, effective, aesthetic
try Pareto+ for advanced features