Hi I was given a Excel file of tabular data with multiple column headings. I was to create a Pivot Table with a percent frequency. When I select the data column to create a pivot table I will need to group the left column(sales range) of a two column pivot table. The right column has the percent frequency of sales. How can I make the groups like this: 0-24.99, 25-49.99, 50-74.99, 75-99.99 etc.. Its not letting me for some reason
Solved by X. H. in 27 mins