Product Range with the help of Pivot Option

To know the product range as per the below steps:

If you have different MRP of  product then you can easily get the details different price range with the help of "pivot group"

Step 1

Drag MRP into "Rows Field", Product to Columns and QTY to "Value Field".

Step 2

Right click on the MRP field and click Group as shown below.

Step 3

In the Grouping give starting and ending values along with the by value as shown below

Step 4 ( result)