1 of 1 people found this helpful
Hi Sakshi Kaul
Here I have attached step by step screen shots.
First creat a basic view by dragging states in Row and Sales Label . Then click on Highlighted area in Image to view value in Descending to Ascending Order like below Image.
Now Drag States in filter area and it will open a window like below.
Select Top-->By Filed -->then check the value in image. You can customize the value as well according to your requirement.
Click on Sales Value like below image and Choose Quick Table Calculation --> Percent of Total
It will give you
the top 10 States and What % of the revenue do they represent.
Please mark correct and Helpful if it works for you and Let me know if you have more question on this